Adding like occurences

[Annette]

I can't figure this one out and need help. Sheet1 has names in col 1 and
values in col 2 -

I want to add totals together for everytime a certain name is found in col 1
in the sheet 2. (Name is listed multiple times on sheet 1)

This is easy but I can't remember how to do it!

Thanks for any help provided.

Annette

 

[PCLIVE]

=SUMIF(Sheet1!A1:A20,A1,Sheet1!B1:B20)

A1 = the Name you want totals for.

HTH,
Paul

 

[Annette]

THAL (this helps a lot!) Thanks!

=SUMIF(Sheet1!A1:A20,A1,Sheet1!B1:B20)

A1 = the Name you want totals for.

HTH,
Paul