=SUMIF('N651 DAILY TRIPS'!$A$2:$A$2000,"<="&'BY PAY WEEK'!A2,'N651 DAILY
TRIPS'!$E$2:$E$2000)

The above function works, but I need to modify it. Is there a formula where
you can use something like =&betweena2&b2? I am trying to modify the above
formula to be =to and between 2 different dates, does anyone know a way to do
this? I am also trying to do a count function, with the same ranges as above
but I do not want to count blanks and I need to add two columns together that
meet the same criteria of "<="&'by pay week'!a2.
--
Rainy