nesting functions

[Guest]

=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.

 

[Ron Rosenfeld]

=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.

In general, to use SUMIF to get events that are between two dates, use a
construct of the type:

=SUMIF(range,">=" & start_date, sum_range) -
SUMIF(range, ">"& end_date, sum_range).


--ron