average of different rows

C

climate

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

Castell

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