+ Reply to Thread
Results 1 to 3 of 3

nesting functions

  1. #1
    Rainy
    Guest

    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. #2
    Ron Rosenfeld
    Guest

    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. #3
    Gary Brown
    Guest

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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