Doubt about countif

[LUCADIROMA2004]

Hallo,

I've this little problem to solve.

I have a list of names in a column. Every name has one of the following values to associate with: 1 or 0.5.

- Mr John (value 1)
- Mr Morrison (value 0.5)
- Mr Morrison (value 0.5) (a single name could be present more times)
- Mr X (value 1)
- Mr X (value 1)

and so on.

I need the sum for every single name in a separate cell.

for egg
Mr Morrison 1 (0.5+0.5)
Mr X 2

and so on

 

[Fluff]

Hi & welcome to MrExcel
how about
=SUMIF($A$2:$A$15,A2,$B$2:$B$15)

 

[LUCADIROMA2004]

Hi & welcome to MrExcel
how about
=SUMIF($A$2:$A$15,A2,$B$2:$B$15)

Great! It solved my problem.

Thanks a lot.

 

[Fluff]

You're welcome & thanks for the feedback