COUNTIFS: Matching fields between dates...

[benste]

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

 

[MARK858]

See your other thread. Don't duplicate questions.
Point 21 in the link Peter provided

 

[FDibbins]

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]

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

b

 

[benste]

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