Rookie Help with a Baseball Stats spreadsheet

[Dog Man]

I downloaded a MS Excel spreadsheet for keeping track of our 8 year old Baseball Team's game and individual stats.

I question is how do I make a seperate area in the sheet that automatically keeps a running total of each kids, batting average, hits, runs, etc.?

I have the spreadsheet, but don't know how to attach it to this for anyone to see.

Any help would be appreciated.

Thanks!

Keith

 

[MDuff]

I downloaded a MS Excel spreadsheet for keeping track of our 8 year old Baseball Team's game and individual stats.

I question is how do I make a seperate area in the sheet that automatically keeps a running total of each kids, batting average, hits, runs, etc.?

I have the spreadsheet, but don't know how to attach it to this for anyone to see.

Any help would be appreciated.

Thanks!

Keith

With out seeing it I relly can't recomend much but have you looked at the sumif and Countif formulas

Also if you have Excel 2007 there is an averageif fomrual as well

I found this link by doing a search on it in google

http://www.techonthenet.com/excel/formulas/sumif.php

Hope this helps