Excel 2007 : Count data if multiple conditions are met

[ataylor91]

Hi,

I am working on a spreadsheet which tracks the progression of a sales process. I'm tracking data from initial client contact, closing dates, and sales information for a service.

I'm trying to count the number of clients who booked a service if their initial call date is between two specific dates.

I've tried a COUNTIFS and an IF statement but neither of them work.

Key Info
Everything is formated as a Date
A3 = Date 1
B3 = Date 2
J = Initial call date
M = Date of service (cells are either blank or a date)

What I've Tried

COUNTIFS
condition 1: j>=date 1
condition 2: j>=date 2
condition 3: m is not blank - I can't get this part to work.

=COUNTIFS(J9:J70, ">=" &A3,J9:J70,"<=" &B3,M9:M70,"="&"")


IF Statement

=IF(and(J9:J70">="&A3,J9:J70"<="&B3),counta(m9:m70))

Please let me know if you need more information.

Thanks,
Alicia Taylor

[NBVC]

Try perhaps:

=COUNTIFS(J9:J70, ">=" &A3,J9:J70,"<=" &B3,M9:M70,"<>")

[ataylor91]

Thank you. That solution worked.