Forum Discussion
How to Have Cells Sum'ed Even if a Cell is Blank
Hi! So I am summing the numbers in the picture below. The number populates based on an =IF function based on the cell before it. With the "N/A" in the cell before it, the cell returns "". When I then...
I presume you mean SUM does not work because one of the cells has a #VALUE! error.
If you'd like to sum and ignore errors, you can use AGGREGATE.
=AGGREGATE(9,6,A1,C1,E1,G1)