G Guest Mar 14, 2007 #1 in excell how do I take a number from the same cell in multiple sheets and then take an average?
G Gord Dibben Mar 14, 2007 #3 =AVERAGE(Sheet1:Sheet10!A1) If your sheets have unique names rather than the standard Sheet1, Sheet2 etc. best to insert a dummy sheet at beginning and another at end. Name these Start and End. Formula will be =AVERAGE(Start:End!A1) Any sheets between Start and End will be included. Gord Dibben MS Excel MVP
=AVERAGE(Sheet1:Sheet10!A1) If your sheets have unique names rather than the standard Sheet1, Sheet2 etc. best to insert a dummy sheet at beginning and another at end. Name these Start and End. Formula will be =AVERAGE(Start:End!A1) Any sheets between Start and End will be included. Gord Dibben MS Excel MVP
