Korean Job Discussion Forums

[alljokingaside]

I have speaking tests coming up for school and need to test the whole friggin school. Don't feel like spending house slaving at data entry, so I'm creating an spreadsheet to automate most of it for me.

So far, I've set up a file that has a sheet for each grade with student number and test section. Basically, I enter the numbers and it sums them up for me. (eg Class 1-1, student no. 10111, etc.)

All I need to know now is :

How to carry that information across sheets. (eg The sum info from "Sheet 1-1"[eg info from Sheet 2, B1] to "Summary"[eg sheet 1, C]3)

ugh, I hate Excel most days....

[YTMND]

I don't use MS, but I thought you could assign a formula in the "C" cell (if A+B=C for example).

=SUM(A1:B1)

For 2 different sheets, check this page http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm

[crsandus]

=Sheet1!A1+Sheet2!A1

So you just add "SheetXcell!" in front of the cell you want in the formula. The above formula adds the value from sheet 1 A1 with sheet2 A1 and the sum is in sheet 3 A1.

[alljokingaside]

sweet. thanks. worked like a charm

I would attach a copy for general usage....but there doesn't seem to be a way to attach the file here