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: =""
As variant
=IF(ISNA(XMATCH(,A1:A20)), "no blank cells", SUM(A1:A20))if you mean blank cells, not cells with empty string "".
This works too. Thank you.
