ExcelBanter - CALCULATE AVERAGE BETWEEN WORKSHEETS

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CALCULATE AVERAGE BETWEEN WORKSHEETS (https://www.excelbanter.com/excel-discussion-misc-queries/3818-calculate-average-between-worksheets.html)

DEEKABEE

CALCULATE AVERAGE BETWEEN WORKSHEETS

TRYING TO AVERAGE NUMBERS FROM DIFFERENT WORKSHEETS WITHIN SAME WORKBOOK.

tjtjjtjt

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

"DEEKABEE" wrote:

TRYING TO AVERAGE NUMBERS FROM DIFFERENT WORKSHEETS WITHIN SAME WORKBOOK.

All times are GMT +1. The time now is 10:16 AM.