Thread: SUM - Counting Entries by date range

Hello All,

Need some assistance on a formula (see below):

=SUM(IF('RAC Current Line Items'!$E$2:$E$65536="B/M",IF('RAC Current Line Items'!$K$2:$K$65536=12,IF('RAC Current Line Items'!$F$2:$F$65536<>"A-A",1,0),0),0))

I need to change the item in Red (the second "IF" statement) to filter on a date range. I would like for it to look for all items within 06/01/2008 - 06/30/2008, but I'm unsure of how to put in the range or keep the formula working.

My objective is to count the number of items where col. E references "B/M", and where Col K falls on or between June 1st and 30th, and items where col F does not equal "A-A".

Hope this makes sense, let me know if you need additional data.

Thanks!
Lindsay

Lindsay

Try this

=SUMPRODUCT(--('rac current line items'!$E$2:$E$65536 = "B/M"),--(YEAR('rac current line items'!$K$2:$K65536)=2008),--(MONTH('rac current line items'!$K$2:$K65536)=6),--('rac current line items'!$F$2:$F65536<>"A-A"))

It doesn't have to be array entered.

rylo

Rylo,

Yep, that's what I was looking for... Thanks so much!!!

Lindsay