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