ExcelBanter - excel average function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel average function (https://www.excelbanter.com/excel-discussion-misc-queries/91648-excel-average-function.html)

twometer

excel average function

How do you use the average function across 3 or more spreedsheets?

Ardus Petus

excel average function

If the 3 target cells have same address (within their respective sheet) AND
sheets are contiguous, you can use:
=AVERAGE(Sheet1:Sheet3!A1)

Cheers
--
AP
"twometer" a écrit dans le message de
news: ...
How do you use the average function across 3 or more spreedsheets?

ufo_pilot

excel average function

This could be in Sheet1 A2
=AVERAGE(A1:D1,Sheet2!A1:D1,Sheet3!A1:D1)

"twometer" wrote:

How do you use the average function across 3 or more spreedsheets?

All times are GMT +1. The time now is 06:46 PM.