Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stagnant cell for counting filtered data
I want to keep one cell that houses the count of the data depending on how it
is filtered and that cell remain visible despite how it is filtered. I can't get the formula =COUNT(C9,C1:C100) to work or get it to stay visible if I change the filter. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stagnant cell for counting filtered data
Place the formula in row 1 that contains your titles...........assuming you
have these. =SUBTOTAL(2,C2:C100) the 2, means count If you don't have titles in row 1, place the formula after a blank row below your data. Note: you use COUNT in your original. COUNT only counts numerics. Maybe you want COUNTA which would be =SUBTOTAL(3,C2:C100) For more options on subtotal function see help. Gord Dibben MS Excel MVP On Tue, 16 Dec 2008 12:20:03 -0800, Lyn wrote: I want to keep one cell that houses the count of the data depending on how it is filtered and that cell remain visible despite how it is filtered. I can't get the formula =COUNT(C9,C1:C100) to work or get it to stay visible if I change the filter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtered Counting | Excel Discussion (Misc queries) | |||
Change cell value of filtered data | Excel Discussion (Misc queries) | |||
cell link from the filtered data | Excel Discussion (Misc queries) | |||
Counting Frequency of Filtered Data | Excel Worksheet Functions | |||
counting unique numbers in filtered data | Excel Worksheet Functions |