How to average EXCEL tables across files?

How to average EXCEL tables across files can be solved as follows:

Using the AVERAGE function,

=AVERAGE(L5:M 12，[Book 1]Sheet 1！ L5:M 12)

The above formula is to find the average of sheet 1 2 in this table L5:M 12 and file book1. If there are 24 files, write them down one by one. If every other cell area asking the price is the same, such as L5:M 12, it is best to put these 24 tables in different worksheets in a unified file, so that,

= average (Sheet 1:Sheet24! L5:M 12)

Appreciate "Qinyuan Spring Snow"

Which basic company of China Railway is good?

How about Jingyujiao 15 produced by Kweichow Moutai Technology Development Co., Ltd.

How much does the fruit of dancing earn?

Brief introduction of personal information of Wang Yuanyuan women's volleyball player Wang Yuanyuan.

How to find a job in Zhaopin?

How to write college students' resume job hunting intention

What are your three favorite places to visit in Zhumadian City, Henan Province?

Liu Yongfu's resume.

Tomorrow's flower novel txt is free.