| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Average and dispaly in another worksheet
I'm working on a project worksheet including project and the % of time each
staff is working on the project by week. I want to show a monthly summay on a different worksheet in the same workbook. I've linked the staff and projects, now I want to calculate the monthly average and have it displayed in the new sheet. Here's my formula for the average calculation =IF(ISERROR(AVERAGE(P3:S3)),"",(AVERAGE(P3:S3))) -- Flipper |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dispaly results, rather than a formula | Excel Discussion (Misc queries) | |||
| Appropriate number format to dispaly time in hours in XY chart | Charts and Charting in Excel | |||
| How to Calculate Average | Excel Discussion (Misc queries) | |||
| dispaly a raw at all times | Excel Discussion (Misc queries) | |||
| how to dispaly date as Mon 2 Dec | Excel Discussion (Misc queries) | |||
Threaded Mode
