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