Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub countm in filter
Hello,
there is a fuction in excel that can subtotal whatever we filter. Is there any fuction in a " CountA" which can subcount what ever we filter in the worksheet?. I tried to look up all the functions but none that can subcount the data that we filter. Appreciate any ideas on this. Thanks, Frank |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub countm in filter
Hi,
I may have misunderstood but if you simply want to add up the visible data in a filtered list try:- =SUBTOTAL(9,A1:A14) If your un-filtered list is in A1-A14 put this in A15 Mike "Frank Situmorang" wrote: Hello, there is a fuction in excel that can subtotal whatever we filter. Is there any fuction in a " CountA" which can subcount what ever we filter in the worksheet?. I tried to look up all the functions but none that can subcount the data that we filter. Appreciate any ideas on this. Thanks, Frank |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub countm in filter
Thank you Mike, I thought that it is true for only sum, in fact the ref.3 is
for countA. Frank "Mike H" wrote: Hi, I may have misunderstood but if you simply want to add up the visible data in a filtered list try:- =SUBTOTAL(9,A1:A14) If your un-filtered list is in A1-A14 put this in A15 Mike "Frank Situmorang" wrote: Hello, there is a fuction in excel that can subtotal whatever we filter. Is there any fuction in a " CountA" which can subcount what ever we filter in the worksheet?. I tried to look up all the functions but none that can subcount the data that we filter. Appreciate any ideas on this. Thanks, Frank |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub countm in filter
If you want to do a COUNTA of just the visible rows then use this:
=SUBTOTAL(3,range) There are other parameters that can be used instead of 3 to give you different functions - check out Excel Help under SUBTOTAL for the others. Hope this helps. Pete On Jul 31, 9:02 am, Frank Situmorang wrote: Hello, there is a fuction in excel that can subtotal whatever we filter. Is there any fuction in a " CountA" which can subcount what ever we filter in the worksheet?. I tried to look up all the functions but none that can subcount the data that we filter. Appreciate any ideas on this. Thanks, Frank |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub countm in filter
Hi,
Hi, You can use this function. COUNTA Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array. Syntax COUNTA(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values you want to count. Remarks A value is any type of information, including error values and empty text (""). A value does not include empty cells. If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored. If you do not need to count logical values, text, or error values, use the COUNT function. Challa Prabhu "Frank Situmorang" wrote: Hello, there is a fuction in excel that can subtotal whatever we filter. Is there any fuction in a " CountA" which can subcount what ever we filter in the worksheet?. I tried to look up all the functions but none that can subcount the data that we filter. Appreciate any ideas on this. Thanks, Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |