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

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

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