# SumIfs Formula is not working

1. ## 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

2. ## 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. ## 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

4. ## re: SumIfs Formula is not working

Did you copy that formula down for the other names?

5. ## 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. ## Re: SumIfs Formula is not working

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

7. ## Re: SumIfs Formula is not working

Glad to help & thanks for the feedback

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

#### 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