Forum Discussion
Array formulas and spilling
...sum of the non-empty cells to another single cell
in C1:
=SUMIF(A1:A8,"<>",A1:A8)That would work even if empty cells contain something like: =""
...sum of the non-empty cells to another single cell
in C1:
=SUMIF(A1:A8,"<>",A1:A8)That would work even if empty cells contain something like: =""
Perfect! Does exactly what I want it to do. This works with the 'Average' function as well. Thank you.
If this works as you expect I probably misunderstood something as well => Use Detlef's one:
=SUM(A1:A8)
Same goes with Average=AVERAGE(A1:A8)Could you unmark the current Best response and mark the one from Detlef instead please?
Thanks & nice day...
Perhaps I misunderstood the question: to sum only if there are no blank cells in the range, if at least one blank cell then return something else.
Otherwise that's as Detlef_Lewin suggested.
