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.