Summing multiple instances of the same name

[richard oldcorn]

Using Excel2007 / Vista

Weekly I receive commission payment data. Essentially 2 columns, Col A the client name, Col B the commission amount. I like to sort the data so that I have a total commission amount for each client
Firstly I sort the 2 Cols alphabetically. Where there is only one instance of a client name, the total commission is obvious.
But any client can appear several times (anything up to 6) with corresponding commission amounts for each name occurrence.
One week a client may not appear at all, or they may appear from 1 to 6 times.
I seek a formula which, where there are multiple instances of the same client name. will total all the commission payments for that client. Naturally the formula can be in a new Col.
Thanks and regards,

Richard Oldcorn

 

[wsjackman]

for the two cells with "mike" (cells a7 and a8 maybe)
go to an empty cell and enter =a7=a8
if you get false there are extra charcters in one of the cells.

 

[richard oldcorn]

MAny thanks

This time I retyped the formulae both with and without the "*", and both now give 13. A relief!

When I cut and paste I suspect one or more characters were treated as text by Excel, or somesuch error.

But the Mike formula now only sums instances of multiple consecutive occurrences of "Mike", whereas I need it to sum all instances of multiple names....?

I am about to explore the Sub Total feature which I discovered late last night on p441 of "Learn EXcel 2007 from Mr Excel" which looks promising.

Hope to find some time later today....

Again, many thanks thus far

Richard