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