nesting functions

=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

On Tue, 31 May 2005 15:58:01 -0700, "Rainy" <[email protected]>
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.

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

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
[email protected]
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