Forum Discussion
Using Countifs to Calculate Headcounts
Hi Team, In my attached screenshot I am wondering how I can use COUNTIFS to calculate the current Headcount of employees based on the following conditions. Countifs; 1. The employee class is N...
Could I offer a suggestion? Let's make it simpler.
Your set of conditions is complex enough that you might be better suited to the use of "helper columns" to test one or at most two conditions and yield a "Y" or some other value, that could then be used as the basis for counting.
See the attached. I didn't try to verify the number...will leave that to you.