Forum Discussion
Count if date range using subtotal
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.
brunotavares Sorry, didn't get the subtotal issue. Can you upload a file/screenshot demonstrating what you are facing?
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")
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.
- It is hard to explain hahah but you gave me a good idea! Thanks a lot.