Forum Discussion
Solved
Array formulas and spilling
Is there a way to test for a value in a range of cells and then, if some of the cells are not empty, send the sum of the non-empty cells to another single cell? I have been experimenting with formula...
...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...