| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count only visible cells
I am using an autofilter on a set of data. I would like to use a countif
field to summarize the visible cells only. So, every time I change the autofilter I would change the criteria counted. Any ideas out there? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count only visible cells
Look at the subtotal function in help, it works on visible cells only
=SUBTOTAL(9,A2:A1000) will sum A2:A1000 and when filtered it will sum only the visible cells in A2:A1000 =SUBTOTAL(3,A2:A1000) will count non empty visible cells -- Regards, Peo Sjoblom http://nwexcelsolutions.com "bnkone" wrote in message ... I am using an autofilter on a set of data. I would like to use a countif field to summarize the visible cells only. So, every time I change the autofilter I would change the criteria counted. Any ideas out there? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count only visible cells
Thanks,
Subtotal(3,) did the job. "Peo Sjoblom" wrote: Look at the subtotal function in help, it works on visible cells only =SUBTOTAL(9,A2:A1000) will sum A2:A1000 and when filtered it will sum only the visible cells in A2:A1000 =SUBTOTAL(3,A2:A1000) will count non empty visible cells -- Regards, Peo Sjoblom http://nwexcelsolutions.com "bnkone" wrote in message ... I am using an autofilter on a set of data. I would like to use a countif field to summarize the visible cells only. So, every time I change the autofilter I would change the criteria counted. Any ideas out there? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to count cells contining one, or more STRIKETHROUGHS? | Excel Discussion (Misc queries) | |||
| Count cells with strikethrough font? | Excel Worksheet Functions | |||
| Copy visible cells only | Excel Discussion (Misc queries) | |||
| Trouble Coping Visible Cells | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Hybrid Mode
