Hi
I have to sum an array of cells A1+A5+A6+A9 but some of those cells have a zero value or is blank. What formula do I need to ignore those values so not to get an error in the totals cell.
Thanks
Hi
I have to sum an array of cells A1+A5+A6+A9 but some of those cells have a zero value or is blank. What formula do I need to ignore those values so not to get an error in the totals cell.
Thanks
Battledeck,
The Sum() function ignores text and counts blank cells as 0. So if A1 is blank, A5 is 1, A6 is 0, and A9 is 2, it would be 0+1+0+2 = 3, which is the correct sum:
=SUM(A1,A5,A6,A9)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks tigervator
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks