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
Bookmarks