Jan 13 2022 11:09 AM
I am trying to add the subtotal function to be able to count only the filtered values. I want to count only the employees that have been hired in 2022. So, my table looks something like this:
Name Group Hiring Date
John | A | 13/01/2022 |
Peter | B | 12/01/2022 |
Wesley | B | 07/03/2022 |
Jennifer | B | 18/12/2021 |
I was using this formula and it was working ok (where the output is equals to 3).
=COUNTIF(C2:C5,">01/01/2022")
However now my desired output in case I filter "Group B" for example will be 2.
I know that I should use subtotal but I couldn´t add the formula correctly. Can anyone help me with that?
Thanks a lot!
@Riny_van_Eekelen maybe you can help me out with that because you already helped with something similar a few months ago!
Jan 13 2022 11:20 AM
Jan 13 2022 11:29 AM
Jan 13 2022 11:32 AM
@brunotavares Then choose a cell where the user can enter A or B or C and link to that cell. See picture where B is entered in E3.
Jan 13 2022 11:35 AM
Jan 13 2022 11:44 AM
@brunotavares Sorry, didn't get the subtotal issue. Can you upload a file/screenshot demonstrating what you are facing?
Jan 13 2022 12:01 PM - edited Jan 13 2022 12:02 PM
@Riny_van_Eekelen Alright, I just attached the file with some comments and also a screenshot. The formula in yellow that I am using is
=COUNTIF(Table6[HIRING DATE],">01/01/2022")
Jan 13 2022 12:11 PM
Solution@brunotavares Why filter on GFK? Just enter the group in some other cell and use the formula I mentioned in my earlier post. Otherwise, add one more filter for the year 2022 only and then add a "Total Row" to count the number of row that fulfil the criterion.
See attached.
Jan 13 2022 12:33 PM
Jan 13 2022 12:11 PM
Solution@brunotavares Why filter on GFK? Just enter the group in some other cell and use the formula I mentioned in my earlier post. Otherwise, add one more filter for the year 2022 only and then add a "Total Row" to count the number of row that fulfil the criterion.
See attached.