+ Reply to Thread
Results 1 to 3 of 3

SUMIF has me wacky

  1. #1
    Registered User
    Join Date
    02-09-2007
    Posts
    2

    SUMIF has me wacky

    I'm using the following formula.

    =SUMIF($G$7:$G$31,A122,C122)

    The Range looks as follows.
    1
    3
    5
    7

    The Criteria is a cell with the value of: 5

    The Sum Range is one cell with the value of: 50,000.00

    When I open the Function Arguments window it tells me

    RANGE = {1,3,5,7}
    CRITERIA = 5
    SUM_RANGE = 50000

    But the FORMULA RESULT is 64000

    I can not determine where the extra 14000 is coming from. I have tried everything I know to solve this. FORMULA AUDITING, EVALUTATE FORMULA, etc. HELP!!!!

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I'm not so sure you want to use SUMIF for this problem... try this formula, and tell me if it works

    =IF(MATCH(A122,$G$7:$G$31,0),C122,"")

  3. #3
    Registered User
    Join Date
    02-09-2007
    Posts
    2

    Perfect - Thank you!!

    =IF(MATCH(A122,$G$7:$G$31,0),C122,"")

    Works Perfectly!!

    Thank You

+ 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