Countif OR Sumproduct OR Istext????

B

Baxter

I'm really struggling with the appropriate formula to use in Sheet 2 to sum
the number of applicants for a specifc role (column C) that also have an
interview date in column D in Sheet 1.

A sample of the Sheet 1 data:

Initial Inquiry Name Role Interview

02-Apr-09 Bill Driver 06-Apr-09
03-Apr-09 Mary Visitor 05-May-09
07-Apr-09 Fred Visitor
08-Apr-09 Bob Visitor 14-Apr-09
09-Apr-09 Laurie Driver
15-Apr-09 Edna Driver
21-Apr-09 Michelle Driver 24-Apr-09
28-Apr-09 Steve Visitor

Essentially, on Sheet 2 I want to know how many visitors I actually
interviewed and how many drivers I interviewed, etc.

Thanks in advance!
 
J

Jacob Skaria

Try the below

'Number of drivers interviewed
=SUMPRODUCT((Sheet1!C1:C100="driver")*(ISNUMBER(Sheet1!D1:D100)))

'Total number interviewed
=COUNTIF(Sheet1!D1:D100,">0")


If this post helps click Yes
 
Top