EXCEL i have a formula example.. IF(C20,SUM(C2),"")
Use SUM() to add your subtotals (not +), it will ignore the "blanks"...
--
Regards,
Luc.
"Festina Lente"
"rkordet" wrote:
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
|