Count if with multiple criteria

[Raquel]

I have a spreadsheet that I am trying to do a count if formula on. The first
column contains a date. The second column contains a number. I want to
count if Column A has a date between 8/1/2005 and 7/31/2008 and if column B
has >19 in it. Is anyone familiar with this?

 

[Mike H]

Raquel

Try this with your start date in d1 and end date in d2

=SUMPRODUCT((A1:A20>D1)*(A1:A20<D2)*(B1:B20>19))

Mike

 

[Francis]

Hi

try this
=SUMPRODUCT(--(A2:A36>DATE(2005,8,1)),--(A2:A36<DATE(2008,7,31)),--(B2:B36>19))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

 

[Francis]

Hi
if you are using XL2007, try this COUNTIFS

=COUNTIFS(A:A,">"&DATE(2005,8,1),A:A,"<"&DATE(2008,7,31),B:B,">19")
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another