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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Trying to find additional ranges outside of min, max, and average 2
Need Help with a VBA subroutine 0
Need help with average/lookup formula 2
Repeating a row other than the 1st row as the header row in a table from next page 1
averaging multiple items from one list 2
calculate last 4 data points in a column (with sometimes blank rows) 7
Calculating an average of data between two dates 1

Top