| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal Countif
If I have a filter on column "A..G" and then I filter on ecolumn for x
criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
Hello Alberto,
what is the reason to use subtotal? this formula will ignore hidden and filtered rows. is it possible to use sum(A5:A200)? "Alberto Ast" wrote: If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
Is there an option to countif( ) those cells
after being filter as above? It can be done. What column do you want to perform the "countif" on and what's the criteria? -- Biff Microsoft Excel MVP "Alberto Ast" wrote in message ... If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
I need to count the rows left after the filtering of some rows... when I need
to add non filtered data I use subtotal... but it only adds up... need a similar that will count not add. "eksh" wrote: Hello Alberto, what is the reason to use subtotal? this formula will ignore hidden and filtered rows. is it possible to use sum(A5:A200)? "Alberto Ast" wrote: If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
I need to count the rows left on Column A after filtering some dates out.
"T. Valko" wrote: Is there an option to countif( ) those cells after being filter as above? It can be done. What column do you want to perform the "countif" on and what's the criteria? -- Biff Microsoft Excel MVP "Alberto Ast" wrote in message ... If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
Try...
=SUBTOTAL(3,A5:A200) ....which will count the number of visible rows in A5:A200 containing data. -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , Alberto Ast wrote: I need to count the rows left on Column A after filtering some dates out. "T. Valko" wrote: Is there an option to countif( ) those cells after being filter as above? It can be done. What column do you want to perform the "countif" on and what's the criteria? -- Biff Microsoft Excel MVP "Alberto Ast" wrote in message ... If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Countif
Thanks, this is what I needed.... thanks.
"Domenic" wrote: Try... =SUBTOTAL(3,A5:A200) ....which will count the number of visible rows in A5:A200 containing data. -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , Alberto Ast wrote: I need to count the rows left on Column A after filtering some dates out. "T. Valko" wrote: Is there an option to countif( ) those cells after being filter as above? It can be done. What column do you want to perform the "countif" on and what's the criteria? -- Biff Microsoft Excel MVP "Alberto Ast" wrote in message ... If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter criteria... Is there an option to countif( ) those cells after being filter as above? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif & subtotal functions | Excel Worksheet Functions | |||
| COUNTIF & SUBTOTAL | Excel Worksheet Functions | |||
| but < subtotal (3,...) or countif | Excel Worksheet Functions | |||
| COUNTIF Subtotal Function? | Excel Discussion (Misc queries) | |||
| Subtotal And Countif | Excel Discussion (Misc queries) | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
