I need to consolidate data from 3 different worksheets?

C

CG

I need to consolidate data from 3 worksheets, each having 4 rows of reference
information, that will calcuate the average of all 3 worksheets onto a 4th
worksheet. How do I do this? I have to use Excel spreadsheets.
 
W

woon san

CG,

Assuming you have
Sheet 1 Cell A1 = 1
Sheet 2 Cell A1 = 2
Sheet 3 Cell A1 = 3

Type the following Formula in Sheet 4 Cell A1
=AVERAGE(Sheet1!A1,Sheet2!A1,Sheet3!A1);
You should get ans: 3 in Sheet 4 cell A1

Copy and paste formula to the rest of the cells.

;)
 
Top