EXCEL i have a formula example.. IF(C2>0,SUM(C2),"")

[Guest]

i am doing subtotals (manually) within one column

1
2
3 subtotal
4
4
4
12 subtotal

at the top, i want to add the subtotals to get the overal total. However,
in each subtotal argument, i want to suppress any ZERO's, but at the top, the
overall total of the subtotals gives me a #VALUE instead of a numerical
total.
How can i supress 0's in the subtotals, and also have the overal total cell
return a total and not a #VALUE
thank you
rkordet

 

[Guest]

Use SUM() to add your subtotals (not +), it will ignore the "blanks"...