G
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
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