ExcelBanter - average of different rows

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - average of different rows (https://www.excelbanter.com/excel-worksheet-functions/182666-average-different-rows.html)

climate

average of different rows

Hi
I want to average data in column I in many sheets with different rows.
thanks for your help.
regards

Castell

average of different rows

Write something like this:
"=AVERAGE(Sheet1!A1:B1,Sheet2!D9:E16,Sheet3!K7:N14 )"

"climate" wrote in message
...
Hi
I want to average data in column I in many sheets with different rows.
thanks for your help.
regards

All times are GMT +1. The time now is 05:28 AM.