Cricket Bowled overs summary

[ayubkhan]

Dear Sir,
I have a list of two bowlers who have totally bowled 4 overs, In this list we have the runs they had given in each ball of an over and wickets they had taken.

But i do not know how to bring the summary of each bowler. Now i need to bring automatically in A2 the bowler name,B3 the number of overs shane has bowled,c3 the total runs that he has given in his total overs, d3 the number of wickets he has taken.

I had upload the sheet and kindly request you to insert functions/formulas.

 

[Somendra Misra]

Hi,

See your file.

Regards,

 

[ayubkhan]

Thank you sir, I am working on a cricket scoring sheet and i will be back to you.

 

[Somendra Misra]

You are Welcome.

Regards,