Problem using SUMIF function

Hi,

I have a list of names (B3:B19). I want to add the sales figure (C3:C19) of similar names. I have attached my excel file.
My code does not work =SUMIF(B3:B19,(EXACT(B3,B4)=TRUE),C3:C19)

I understand that the EXACT function is case sensitive. Any way to compare names that is not case sensitive and add them up?
Any other function is welcome!

Thank you.

Hi, welcome to the forum

why not just this...
=SUMIF($B$3:$B$19,B3,$C$3:$C$19)

To excel (for this purpose), john, JOHN, jOhN, JOHN and john are all the exact same name

If that was not the answer you were expecting (from the formula), what did you want?

Try this.....

In D3

=SUMPRODUCT(--(EXACT($B$3:$B$19,B3)),$C$3:$C$19)

and copy down.

This will clean it up a bit...
=IF(COUNTIF($B$3:B3,B3)>1,"",SUMIF($B$3:$B$19,B3,$C$3:$C$19))

Hi,

You can list the names first and do the sumifs,

Ref the attachment