calculating using 3 worksheets in a file

M

mark1124

I have and Excel file which 3 work sheets, in the first work sheet,
have the data in a range of cells, in the second work sheet i hav
another set of data in the same range of cells as that was in the firs
work sheet. I would like to add or multiply the value in the frist shee
with value in the second sheet using the same set of ranges, the outpu
of this calculations, i would like to display in the third sheet in th
same cell ranges as worksheet1 and worksheet2.

Please let me know how i could do this.

MARK112
 
S

saybut

If your data starts from A1 in the first sheet and starts from A1 in the
second sheet: On sheet 3 just type = then select the first cell in sheet
1, type * then select the first cell in sheet 2 and press return.

you can copy the formula down.
 
Top