| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CALCULATE AVERAGE BETWEEN WORKSHEETS
TRYING TO AVERAGE NUMBERS FROM DIFFERENT WORKSHEETS WITHIN SAME WORKBOOK.
|
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Average Macro | Excel Discussion (Misc queries) | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Linear Mode
