I have a multi worksheet issue here. I have data on one sheet and I
want to show reports on a second sheet. I am trying to check
ColumnA1:A1500 for dates that lie between 1/6/07 and 2/3/07, then sum
the cells in ColumnL1:L1500. I can get it to do it if i select
greater than or less than a certain day, but not both. I want to
gather data for a whole month(first friday to first friday). My
working formula is this...
=SUMIF(SHEET1!A5:A1500,"1/5/07",SHEET1!L5:L1500)
I am unable to actually select between two dates for some reason.
Any help would be appreciated. Sorry if there is an easy explanation,
I can't seem to put it together.
TIA

Ryan