Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |