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.
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.