Countif OR Sumproduct OR Istext????

[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!

 

[Jacob Skaria]

Try the below

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

'Total number interviewed
=COUNTIF(Sheet1!D1100,">0")


If this post helps click Yes

 

[Ashish Mathur]

Hi,

You can create a Pivot table. Drag Name to the row area and date to the
data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com