Add cells together that have a certain name associated with them.

Hi all forum and excel newbie here,

I am hoping someone is able to solve this as it will make my job a whole lot quicker,

I have a spread sheet that has info auto populated to it, what i need to do is add up some figures for certain names.

for example in coloumn N are the numbers i need to add but the name i need to get a total for is in column I, to add to my problem some times the amount of rowscontaining the name could be 5 and sometimes it could be 4 etc.

Soooo (no laughing at my example please)

if cell I2 contains the name Karl then take the number from Cell N2 then if the cell I3 contains the name Karl then add Cell N2 to N3 -
if Cell I4 contains the name Karl then take the nunmber from Cell N4 and add it to N2 and N3 BUT if the name is not Karl just add N2 and N3 then start the same for the next name in Cell N4

Excel help.xlsx


Many Thanks

Karl.

Hi and welcome to the forum

(I think you have a few references out, N is empty, so I assumed M - adjust as needed)

If you want to show a column of totals, for each person, use this, copied down...
=SUMIF($I$2:$I$27,I2,$M$2:$M$27)

If you only want to show the total once, next to the 1st appearance of the name, use this, copied down...
=IF(I2=I1,"",SUMIF($I$2:$I$27,I2,$M$2:$M$27))

If you mean you want the total to appear on the last row of that name, and all other occurrences above to be empty/blank, then try this...

O2=IF(I2=I3,"",SUMIF($I$2:$I$27,I2,$M$2:$M$27))

My other formula above was doing it the other way round - putting the total against the 1st occurrence of the name and leaving the others blank
N2==IF(I2=I1,"",SUMIF($I$2:$I$27,I2,$M$2:$M$27))

	M	N	O
1	Hours Charged	1st entry	last entry
2	25.74	64.7162
3	1.11
4	33.27
5	4.60		64.7162

Actually I kinda figured that was what you wanted, but then I thought you wanted the totals inthe main table. Take a look at the attached and see if that is what yoiu want?

you'r welcome.

the 1st formula pulls out the unique names (formula courtesy of 1 of the other senior members)
the next set are pretty much just what I showed you above, just put into a table

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)