+ Reply to Thread
Results 1 to 3 of 3

SUMIF not summing values

  1. #1
    Registered User
    Join Date
    04-04-2010
    Location
    Okinawa, Japan
    MS-Off Ver
    2019
    Posts
    9

    SUMIF not summing values

    All,
    I've looked at a lot of the previous posts on this subject and have tried multiple things, but obviously not the right one. So I've got this table from another source, (Unknown), and am trying to add up like areas and work. I've had to separate many of the different areas that work is being done and the first tab I created worked perfectly. The second one does not.
    I've got a column identifying three different sections and I'm using the SUMIF function to add up area and work. I've cut out a small piece of the entire thing. You can see that the total adds up and the SUMIF for the E & M sections work; however, the R section does not sum the values in the sheet.
    I'd appreciate it if someone could check it out and let me know what boneheaded mistake I'm making.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: SUMIF not summing values

    You have spaces after your "R's" Modify your formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    where the * acts like a wildcard or do a search and replace and remove the spaces.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    04-04-2010
    Location
    Okinawa, Japan
    MS-Off Ver
    2019
    Posts
    9

    Re: SUMIF not summing values

    Thanks ChemistB. I did not see that and thought I ruled that out by replacing the data. I'm going to have to look that up and find out how that happens to prevent it from happening again.
    Peace

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF Not ... Summing
    By Moxioron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2019, 05:54 PM
  2. Using sumif for summing just some values
    By a1b2c3d4e5f6g7h8i9 in forum Excel General
    Replies: 3
    Last Post: 06-24-2015, 05:16 AM
  3. LOOKUP & SUMIF equation (summing values of names on a list)
    By newtotheblock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2015, 03:25 PM
  4. Summing values based on criteria (SUMIF issues)
    By notsamsnead in forum Excel General
    Replies: 4
    Last Post: 08-11-2014, 09:03 PM
  5. Replies: 4
    Last Post: 08-22-2012, 12:18 PM
  6. SUMIF without summing?
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-31-2012, 01:53 PM
  7. sumif(range,"<30",sum range) not summing values that equal 0
    By rantarctica in forum Excel General
    Replies: 3
    Last Post: 01-06-2009, 07:27 PM

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