Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal
Hi,
Is there any excel function for subtotal to ignore cell error while adding up the values in a column ? E.g. A 1 4,084.20 2 #N/A 3 450.00 4 3,965.00 5 #N/A 6 #N/A ----------------- 8,499.20 ( Note : excel formula to add up the column A from A1 to A6 to arrive the subtotal of 8,499.20 ) 10 1,037.20 11 750.00 12 #N/A 13 16,200.00 ---------------------- 17,987.20 ( Note : excel formula to add up the column A from A10 to A13 to arrive the subtotal of 17,987.20 ) ---------------------- 26,486.60 ( Note : excel formula to add up subtotal of 8,499.20 and 17,987.20, grandtotal shows 26,486.60 ) =========== Please help, thanks Regards Lenard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Sort, Subtotal, Label Subtotal, Insert row | Excel Programming |