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!

Try the below

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

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


If this post helps click Yes
---------------
Jacob Skaria


"Baxter" wrote:

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!

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

"Baxter" wrote in message
...
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!