Hi

I have to count cells contingent on names that may be in diferent rows and colums. Viz


a c g k o s w
John 3 3 Peter 2 1
Alex 2 1 Alex 1 3 2
Peter 3 2 John 2 2 1


Name total
John
Alex
Peter

I want to be able to count all of Johns, Peters, and Alex's seperately and put them in the total box (so the total cell for John will add 3+3+2+2+1) and similarly the same for peter and Alex.

Can you please help with a formula or will it require a macro. The format cannot be changed otherwise I would have John a fixed row as with Alex and Peter.

Many thanks in anticipation

Gerry