<< My class is planning a trip to San Fransisco.. And i need to know ho
to keep
track of the fundrasing each student has done and how much they need t
reach
there goal.>>
Here is a simple solution (not elegant but it will work).
ON SHEET 1 (HERE IS WHERE YOU WILL ENTER ALL YOUR RAW DATA)
Enter the goal at Cell A1 (assuming that each student has the sam
goal);
Enter the names of the students on A2, B2, C2, D2, E2 ...
Enter the individual amount raised by each student starting from Row
to, say, Row 100. For example, for student whose name appears on Cel
A2, the first sale will be entered in Cell A3, the second in Cell A4
the third in Cell A4 and so on down the line. I am assuming tha
A1:A100 is more than enough range for the individual entries.
Do the same for the other columns.
ON SHEET 2 (THIS IS YOUR SUMMARY PAGE) DO THE FOLLOWING
Column A will contain the names of the students;
Column B will contain the total amount raised by the students;
Column C will contain the amount needed to reach the goal
Enter the following formulas in the following cells:
Cell A2: =Sheet1!A2
Cell A3: =Sheet1!B2
Cell A4: =Sheet1!C2
and so on, until all the student names appear in Sheet2.
On Cell B2, enter =sum(Sheet1!A3:A100)
On Cell B3, enter =sum(Sheet1!B3:B100)
On Cell B4, enter =sum(Sheet1!C3:C100)
and so on ...
On Cell C2, enter =Sheet1!$A$1-B2 and copy all the way down until yo
reach the last student's name.
This is how it will work. You enter all your raw data in Sheet 1 an
your summary will automatically appear on Sheet 2.
Hope this will help you and good luck in your fundraising.
Regards
