Ignoring Blank-Zero Cells

[Battledeck]

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

[tigeravatar]

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)

[Battledeck]

Thanks tigervator