I 2 quick ?'s

1. What would be the best way to input physical fitness scores for a test on a spreadsheet. Let me explain....100 crunches=100 points, 20 pull ups=100points and under a 17 minute run=100points for a total of 300 points for a perfect score.....can I do a formula to breakdown everyones score by just inputing the criteria? Or maybe importing it from an outside source?

2. I have running scores for various activities, but I want them to be reflected on the first spreadsheet as an overview.....how can I link the totals of certain cells on other sheets to the overview sheet??

Any help is appreciated!!

1. What would be the best way to input physical fitness scores for a test on a spreadsheet. Let me explain....100 crunches=100 points, 20 pull ups=100points and under a 17 minute run=100points for a total of 300 points for a perfect score.....can I do a formula to breakdown everyones score by just inputing the criteria? Or maybe importing it from an outside source?

2. I have running scores for various activities, but I want them to be reflected on the first spreadsheet as an overview.....how can I link the totals of certain cells on other sheets to the overview sheet??

Any help is appreciated!!

## Comment