Forum Discussion

NoviceKB's avatar
NoviceKB
Brass Contributor
Jul 15, 2020

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...
excel
NoviceKB's avatar
NoviceKB
Brass Contributor
Jul 15, 2020

OwenPrice Many thanks for your observation and you are absolutely right!

 

I have modified my initial submission. Can you take a look and let me know if this makes sense to you? It does to me now.

 

If yes, how can I capture this with a formula?

 

Thanks.

OwenPrice's avatar
OwenPrice
Iron Contributor
Jul 15, 2020

NoviceKB 

 

Can you confirm this is what you mean? If we break each condition down into bullets of their own:

 

  1. The employee class is not "Adecco", AND
  2. The employee class is not blank, AND
  3. The contract start date is less than today's date, AND
  4. The contract start date is not blank, AND
  5. Either:
    1. The probation status is not terminated, OR
    2. The probation status is terminated AND
      1. the contract end date is after today, OR
      2. the contract end date is blank

Regarding the bold items - should those actually be probation end date? I wonder whether the actual situation you're trying to capture here are people who have been terminated but they have not finished their probation yet, so they are still active headcount.

Resources