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
Bookmarks