It's not complicated, if you understand it (ain't that always true).

The solution you put forward would get the sum total, but you said you
wanted a list of the amounts, which is what I gave you. I also used the name
in a cell, M1 in my case. You could actually do away with the first formula,
it just returns how ever many instances of the name that are there.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ray" wrote in message
...
Bob,

Your formulas seem 'complicated' to me .... can you explain the logic
used to get to your solution?

My first thought on this was to have the member names (ie Brian G)
listed say in col X (she said somewhere else in the sheet),
and then in column Y have this fomula:
=sumif($B$12:$B$208,X12,$F$12:$F$208)

This could then be copied down for each member .... this solution
assumes that the member names are entered identically each time (in
Col B).

br//ray