COUNTIF problem

P

Phil C

Hi All

I have 2 columns: A has dates (appointment dates), B has integer numbers
(current waiting times in weeks).
I basically want to do:
COUNTIF A1:A20 > 30/06/2007 AND B1:B20 >6
In other words, of those with appointments after 30 June 2007, how many have
already been waiting more than 6 weeks
?? Possible with one statement of the form:
=COUNTIF(AND(A1:A20,">30/06/2007",B1:B20,">6"))

Any help appreciated.

Phil
 
G

Guest

=SUMPRODUCT(--(A1:A100>DATE(2007,30,06)),--(B1:B100>6))

[the "--" converts TRUE/False to 1/0]
 
G

Guest

Try this and put a date into cell C1 to compare
=SUMPRODUCT(--(A1:A100>(C1)),--(B1:B100>6))
 

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

Similar Threads

COUNTIF oddity 1
IF, COUNTIF & AND STATEMENTS 3
Countif 3
if meet critertia then countif(a1:a10, between dates) 3
Please help with countif formula 4
Date formula 3
Problem with SumProduct 5
If & sumproduct formula with text 3

Top