Re: Formating a Spreadsheet for Dummies
Like Jack said, not quite enough explanation with your example for me to deduce what it needs to do.
Hoberz comment also valid (although in the attached example I just made stuff up!) we need your point system.
Your original question, however, says how to link cells on other sheets to the "summary" sheet. If the sheets are in the same workbook, simply type an equals sign in the summary sheet cell, click the tab of the other sheet, click the cell you want and press enter. That will link the cell. There are two cells in my example which are linked with that method.
As for a formula to express scores I assume you mean to calculate the scores of the crunches + pullups + the run. I'm putting crunches as one = 1 point, pullups are times five (because 20 = 100 points).
The run however must have a scale of times/points to be calculated, ie: less than/equal to 17 = 100 points, greater than 17 & less than 18 = 80 points, greater than 18 & less than 19 = 50 points, greater than 19 & less than 20 =10 points, over 20 mins = 0 points. I simply subtracted 20, then 30 then 40 points from each previous value.
Once these values are decided on you could use an "If" statement, or if it is more than maximum 7 conditions an Hlookup or Vlookup for results.
Here's an example I played with to see if we're on the right track... Sheet "Phys. Test" uses "time" formatting for the run, "Phys. Test (2)" uses numbers as minutes and seconds (seconds are converted to decimal equiv.) for the run scores.
Both use "If" statements for their calculations <gr>
Video Tutorials / Excel Dashboards Reports