Vlookups

Hi Andrea

Thanks for your question.
There are different ways in Excel to summarise total amounts for each person. Either use a formular function, a PivotTable or by the Subtotal feature. (Data, Subtotal).

Here's how to total amounts by person with a SUMIF function.

------A---- ------B------
First Name Amount
Steph 9
Diane 6
Diane 20
Diane 15
Anne 8
Steph 13
Terence 14
Terence 10
Diane 9
Linda 9
Diane 20
Steph 13
Diane 15
Linda 20


Amount Summary

Steph 35
Diane 85
Anne 8
Terence 24
Linda 29


=SUMIF($A$2:$A$16,A21,$B$2:$B$16)

This formula works out that Steph's total of 9, 13 and 13 is 35

=SUMIF(Range of names, A21, Range of amounts)

A21 is the criteria ("Steph") and when this founction is copied down it calculates the total for Diane.

Also the $ signs are needed to fix the ranges so the references don't change whn the formula is copied.

Hope this helps with your question.

Regards
Doug
Best STL