Forum Discussion
Solved
Count if date range using subtotal
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: Nam...
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 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.