+ Reply to Thread
Results 1 to 5 of 5

SUMIF between 2 amounts, eg 51>x> -51

  1. #1
    sam158963
    Guest

    SUMIF between 2 amounts, eg 51>x> -51

    I want to sum a corresponding number in column C if the cell in column D is
    between + -50.



  2. #2
    Aladin Akyurek
    Guest

    Re: SUMIF between 2 amounts, eg 51>x> -51

    =SUMIF(D:D,">="&E2,C:C)-SUMIF(D:D,">"&F2,C:C)

    where E2 houses -50 and F2 +50.

    sam158963 wrote:
    > I want to sum a corresponding number in column C if the cell in column D is
    > between + -50.
    >
    >


  3. #3
    Frank Kabel
    Guest

    Re: SUMIF between 2 amounts, eg 51>x> -51

    Hi
    one
    way:
    =SUMIF(D:D,">-50",C:C)-SUMIF(D:D,">=50",C:C)

    or try
    =SUMRODUCT(--(D1:D100>-50),--(D1:D100<50),C1:C100)

    --
    Regards
    Frank Kabel
    Frankfurt, Germany
    "sam158963" <[email protected]> schrieb im Newsbeitrag
    news:[email protected]...
    >I want to sum a corresponding number in column C if the cell in column D is
    > between + -50.
    >
    >




  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    or...

    =SUM((C2:C20)*(ABS(D2:D20)<50))
    Confirm the Formula by pressing Ctrl+Shift+Enter not just Enter.

    Regards,
    Ola

  5. #5
    Harlan Grove
    Guest

    Re: SUMIF between 2 amounts, eg 51>x> -51

    "Frank Kabel" <[email protected]> wrote...
    ....
    >or try
    >=SUMRODUCT(--(D1:D100>-50),--(D1:D100<50),C1:C100)


    More compact,

    =SUMPRODUCT(--(ABS(D1:D100)<50),C1:C100)



+ 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