# nesting functions

1. ## 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

2. ## Re: nesting functions

On Tue, 31 May 2005 15:58:01 -0700, "Rainy" <Rainy@discussions.microsoft.com>
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

3. ## RE: nesting functions

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
gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com
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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1