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.

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.

;)


--
woon san
------------------------------------------------------------------------
woon san's Profile: http://www.excelforum.com/member.php...o&userid=28790
View this thread: http://www.excelforum.com/showthread...hreadid=492363