# Using Countifs to Calculate Headcount

#### NoviceKB

##### New Member
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.

Countif;
1. The employee class is NOT "Adecco" nor Blank.
2. The Contract Startdate is less than TODAY(todays date) and not blank.
3. The probation enddate is more than TODAY and the Probation status is NOT "Terminated" (If status is Terminated but the probation enddate is later than todays date, this should still count as 1 Headcount)

Any ideas how I can use Countifs to solve this

NoviceKB

#### Attachments

89.4 KB · Views: 10

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### ChrisFoster

##### Board Regular
Presuming your data starts in column A, try this;

Code:
``=COUNTIFS(B:B,"<>Adecco",B:B,"<>",C:C,"<=TODAY()",E:E,">=TODAY()",F:F,"<>Terminated")``

#### NoviceKB

##### New Member
THanks for the feedback ChrisFoster.

I tried that formula and it returned zero.

#### NoviceKB

##### New Member
I also want to correct condition number 3 in my original post:

3. The probation enddate is more than TODAY or BLANK and the Probation status is NOT "Terminated" (If status is Terminated but the probation enddate is later than todays date or BLANK, this should still count as 1 Headcount)

Replies
8
Views
221
Replies
4
Views
286
Replies
0
Views
299
Replies
3
Views
55
Replies
4
Views
229

1,127,098
Messages
5,622,681
Members
415,920
Latest member
ExcelNoob28

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back