Count if with multiple criteria
 

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?

Count if with multiple criteria
 

Raquel

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

=SUMPRODUCT((A1:A20D1)*(A1:A20<D2)*(B1:B2019))

Mike

"Raquel" wrote:

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?

Count if with multiple criteria
 

Try:
=Sumproduct(--(A1:A100="8/1/2005"+0),--(A1:A100<="7/31/2008"+0),--(B1:B10019))

adjust ranges to suit.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116346

Count if with multiple criteria
 

Hi

try this
=SUMPRODUCT(--(A2:A36DATE(2005,8,1)),--(A2:A36<DATE(2008,7,31)),--(B2:B3619))
--
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



"Raquel" wrote:

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?

Count if with multiple criteria
 

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



"Raquel" wrote:

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?