+ Reply to Thread
Results 1 to 7 of 7

SumIfs Formula is not working

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    73

    SumIfs Formula is not working

    I had a worksheet that I created last year and I had a hard drive failure so I lost it but I still had some notes so I tried to Re-created. Yesterday actually last two days I believe I had some of you helping me convert text dates into actual dates.

    Now the formula that I was given back when someone helped me create this original worksheet For some reason doesn't work even though the same data is in the same cells from the best of my knowledge.

    In rolls I, J and K there are the name, amount, and total. The formula was written so the amounts in column E would appear as a total amount in column J as I entered the name in column I, then in column K the total would be a sum of all the numbers in column J

    The way the formula in J9 was written was so that there were names in column D and amounts in column E So when I typed a name in column I the total for that name in Column E would be shown. The in K9 I wanted the sum of all of column J.

    So basically in summary, the name amount and total on the far right in columns I, J column K Would basically keep a running total for each name in column D In the amount next to the name in column E.

    This way as I had new names to add in column D with new amounts in column E all I would have to do is type the name in column I and it would keep a total of all the amounts for that name..

    The formula I was given was,

    =SUMIFS($E$647:$E$5000,$D$647:$D$5000,I9)

    I tried to re-create this worksheet so that it would work however because I don't know enough about Excel it's not working even though all the data is in the same cells and same columns to the best of my knowledge. I'm hoping somebody can read the formula and tell me why it's not working. I will attach a copy of an example to show you exactly what it should look like.

    I appreciate any and all help in advance
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,214

    re: SumIfs Formula is not working

    Its because the formula is look at rows 647 to 5000, but they are all empty.
    Try
    =SUMIFS($E$3:$E$5000,$D$3:$D$5000,I9)

  3. #3
    Registered User
    Join Date
    06-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    73

    re: SumIfs Formula is not working

    that works but only for the name Bob the other names that have totals in column E don't transfer the totals

    Thanks for your reply

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,214

    re: SumIfs Formula is not working

    Did you copy that formula down for the other names?

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,161

    Re: SumIfs Formula is not working

    Your thread title does not conform with the Forum Rules. I have changed it for you today. Please take a few minutes to review the forum rules you agreed to and comply with them in the future.

  6. #6
    Registered User
    Join Date
    06-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    73

    Re: SumIfs Formula is not working

    Duh ! no...........lol I just did and now it works !!! THANKS !!

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,214

    Re: SumIfs Formula is not working

    Glad to help & thanks for the feedback

+ 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. [SOLVED] SUMIFS formula not working properly
    By fahadmohsin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2016, 12:03 PM
  2. Sumifs formula is not working properly
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2016, 02:58 AM
  3. [SOLVED] SUMIFS formula not working with Dates
    By Bigred25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2014, 10:25 AM
  4. [SOLVED] Sumifs Formula not working correctly
    By jamaal09 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2013, 09:36 PM
  5. [SOLVED] SUMIFS formula not working in VBA
    By meechie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2012, 03:06 PM
  6. Excel 2007 : SUMIFS Formula Not Working
    By milliemoo in forum Excel General
    Replies: 7
    Last Post: 03-06-2012, 12:16 PM
  7. Sumifs formula not working
    By todd.graff@gmail.com in forum Excel General
    Replies: 6
    Last Post: 09-21-2009, 02:26 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