+ Reply to Thread
Results 1 to 4 of 4

Malfunctioning SUMIF function???

  1. #1
    Registered User
    Join Date
    05-27-2008
    Posts
    7

    Malfunctioning SUMIF function???

    Hello,

    It's been a few months, but another "problem" has sprung:

    I have created a sumif formula, but it does not seem to be working.

    I have used the sumif function since the last time that this wonderful forum helped me, but this time, it doesn't want to work with me.

    I have the proper 'Range', 'Criteria', and 'Sum_Range' selected and the data that is in the Criteria and Range do have exact matches; however, the Sum_Range keeps coming up with a some of 1 in all of the cells containing the formula. I know, for example that the first match should have a sum of 23.

    What's wrong with me or Excel?

    Thanks,

    Rod

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Malfunctioning SUMIF function???

    Can you post a sample of your data, the formula you're using, and what you
    expect it to calculate? (Posting a sample workbook would be even better!)
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    05-27-2008
    Posts
    7

    Example

    Sorry.

    Example Attached.

    Rod
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    05-27-2008
    Posts
    7

    Solved!!!

    I apologize: I found out, through a little more trial and error, that I had juxtaposed the 'Range' and the 'Criteria' selections in the formula. That's what 2 hours of sleep will get you.

    Rod

+ 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