count cell value contingent on other cell conditions

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

Hi

I haven't tried it out yet but I just want to thank you for taking the time to help me.

Many many thanks

Gerry

Hi SGLife
Just to let you know that it does work but yes you are right there hopefully is an easier way as I have 20 names spread over 30 columns !!!!!

If anyone has an easier answer it would be appreciated. I am however very appreciative of SG's answer.

Gerry

Hi
Start time, Finish Time, No of hours worked and names of staff who are supporting those mentioned in column a.

Mant thanks again for your interest

The names in a and k and also in some other colums are the names of service users that need supprted by other staff whose names are also in columns. I have sorted out the times and number of hoursthat they are supported and this determines their session values ie if they get 4 hours support that is 1 session; if they get 8 hours that is two sessions. I am counting all the sessions and subtracting from an original allocation. The problem is that I can't allocate specific rows for each client therefore the cell that calculates the number of sessions needs to be able to identify the cells that have the sessions for each service user and as stated the service user may have their name on different rows. Hope I haven't complicated it further. In other words I am asking find and total all of the sessions for each person supported.

Many thanks again