Follow up Question to Countif

A

Ajay

Hi All

Secondary question could I adapt the formula
=SUMPRODUCT((C1:C36<DATE(2009,1,31))*(I1:I36="Awaiting inspection"))

to give a count using the criteria of between two dates.

Eg Count Awaiting Inspection entries if date in column B is between 1st feb
2009 and 15th Feb 2009.

Many thanx
Ajay
 
T

T. Valko

to give a count using the criteria of between two dates.

Usually, when someone says "between dates" what they really mean is all
dates between, *including* the boundary dates.

Use cells to hold the boundary dates and your other criteria:

A1 = lower boundary date = 2/1/2009
A2 = upper boundary date = 2/15/2009
A3 = Awaiting inspection

Then:

=SUMPRODUCT(--(C1:C36>=A1),--(C1:C36<=B1),--(I1:I36=A3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top