# COUNTIFS: Matching fields between dates...

#### benste

##### New Member
Hello everyone,

I am not very good at this stuff but I would like to know, for example, how many Interns have been hired by the HR between January and March 2013?

A1 Intern
A2 Intern
A3 New Hire
A4 New Hire
A5 Intern
A6 New Hire

B1 Finance
B2 HR
B3 HR
B4 Finance
B5 HR
B6 Finance

C1 01/01/2013
c2 01/13/2013
c3 2/13/2013
c4 5/13/2013
c5 6/13/2013
c6 3/13/2013

I was also wondering how would I use wildcards for this? So if someone wrote HR Dept. in a field instead of just HR?

Any help would be very much appreciated,

Ben

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### MARK858

##### MrExcel MVP
Point 21 in the link Peter provided

Last edited:

#### FDibbins

##### Well-known Member
Hi

Give this a shot.

D1 = Intern
D2 = HR
D3 = 1/1/2013
D4 = 3/31/2013

=COUNTIFS(A1:A6,D1,B1:B6,D2&"*",C1:C6,">="&D3,C1:C6,"<="&D4)

The D2&"*" part will cater for HR_and_anything_else

#### benste

##### New Member
This is fantastic, and i understand whats going on now which is great!! thank you soooo much.

b

#### benste

##### New Member
Hi FDibbins,

That worked really really well with the &"*" for the wild card. For this value, is it possible to say i want *valuea*&"*" and then add another value onto it for that column?

Is it also possible to say: I want to calculate all in that field minus *valuea*&"*"?

I love this website

b

Replies
5
Views
237
Replies
9
Views
197
Replies
2
Views
149
Replies
5
Views
616
Replies
0
Views
228

1,195,722
Messages
6,011,309
Members
441,604
Latest member
CraigThompson

### 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