| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a column of filtered data
I filter data based on labels in column H. I want to sum the the associated
data in column G. How do I do it? If I use tha basic sum function, it sums all the unfiltered data in the column. -- Don Z |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum a column of filtered data
Use this:
=SUBTOTAL(9,G2:G100) or whatever your range is. You can use 109 insted of 9 if you have manually hidden some rows. Other numbers can be used instead of 9 for other functions (COUNT, COUNTA etc) - see XL Help on SUBTOTAL for a complete list. Hope this helps. Pete On Jan 28, 3:34*pm, Don Z wrote: I filter data based on labels in column H. *I want to sum the the associated data in column G. *How do I do it? *If I use tha basic sum function, it sums all the unfiltered data in the column. -- Don Z |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste data to a filtered column, pasting to visible cells only | Excel Discussion (Misc queries) | |||
| Count the Y's in a filtered column that contains Y and N | Excel Worksheet Functions | |||
| how do I select different data in a filtered column in excel 2003? | Excel Discussion (Misc queries) | |||
| Copy data to filtered column | Excel Discussion (Misc queries) | |||
| Information from one column then filtered(?) from another | Excel Worksheet Functions | |||
Linear Mode
