CALCULATE AVERAGE BETWEEN WORKSHEETS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

TRYING TO AVERAGE NUMBERS FROM DIFFERENT WORKSHEETS WITHIN SAME WORKBOOK.
 
Please don't type in all caps. It's considered the equivalent of shouting.

Example:
=Average(Sheet1!A1:A4,'January Sales'!B5:B17,Sheet2!A1:A4)
This would average numbers from 3 different sheets. Notice the ' around the
sheet name which contains a space.
Hope that helps,

tj
 
You must log in or register to reply here.

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

AVERAGE cells on another worksheet when the range is calculated 1
Multiple criteria question 1
Averages from different worksheets 4
Average if - data on separate sheet 3
Averaging across worksheets 1
Average Multiple Worksheets without blanks or zeros 2
Linking multiple worksheets in one workbook 2
Conditional formatting using part of the cells contents 3

Back
Top