You should check out Chip Pearson's website on arrays. This shows you how to
used multiple criteria for sumif and countif.

http://www.cpearson.com/excel/array.htm

HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"Rainy" wrote:

=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