Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using sumif with subtotal
Lights 12,505.00
Solar 23,622.44 Lights 21,771.00 Solar 23,622.44 Lights 23,739.00 Solar 23,622.44 Lights 9,594.00 Solar 23,622.44 Using above data as example, how do I subtotal using sumif where data has been filtered in a larger database? The filtered data base has returned data that has already been correctly subtotalled using function_num 9. This list now contains hidden rows. I now wish to further subtotal the list using criteria lights or solar in the sumif? -- Kind regards, Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif / subtotal / something else? | Excel Discussion (Misc queries) | |||
Subtotal and sumif help | Excel Discussion (Misc queries) | |||
subtotal and sumif | Excel Worksheet Functions | |||
Sumif & subtotal | Excel Discussion (Misc queries) | |||
Subtotal on SumIf | Excel Worksheet Functions |