How do you use the average function across 3 or more spreedsheets?
A Ardus Petus Jun 1, 2006 #2 If the 3 target cells have same address (within their respective sheet) AND sheets are contiguous, you can use: =AVERAGE(Sheet1:Sheet3!A1) Cheers
If the 3 target cells have same address (within their respective sheet) AND sheets are contiguous, you can use: =AVERAGE(Sheet1:Sheet3!A1) Cheers
1,Sheet2!A11,Sheet3!A11)