Hi,

I have a sheet

A B

John 100
Alex 150
John 175
Steve 125

i want to get the sum of the entries for John, say here i have to get the
result as 100+175 = 275. Is there any function for me to do it?

I tried LookUp but its returning only the first value.

Thanks in advance
John,