Slicer_Subtotal_countif_question

[redJohn89]

Hi folks,

I am trying to find a formula to return the count of displayed rows in a filter. I know we use the subtotal function for this, but i have to incorporate two more conditions inside the subtotal function. For example..this is my scenario(refer attached sheet)
If i want to see the count of rows where columns A(status) = "Open" and Column C(Year)=2017 and Column D(Country)="US" when i apply this filter, i only want to count the displayed rows based on this condition.Kindly help

[José Augusto]

Hi

I suppose you want this:

Please Login or Register  to view this content.

[redJohn89]

Hi Jose,

Still not working
If i want to get a specific status for eg in this case Status = "Open", how do i add it to the formula?

[José Augusto]

Try

Please Login or Register  to view this content.

[redJohn89]

THAT WORKED !! One last quick question..i wanted to see just the number of records for one particular column, for eg i want to see all records for Year = 2017 in my sheet. I tried using this formula:
=SUBTOTAL(3,Table1[year]=2017) but it is giving me an error. Any ideas Jose?

[José Augusto]

Hi
You can use

Please Login or Register  to view this content.

or use

Please Login or Register  to view this content.

to solve your problems