And presumably, you work down row from there?

would seem best to do
=IF(ISERROR(AVERAGE(P3:S500)),"",(AVERAGE(P3:S500) ))

Don't want to take an average of an average...

"Flipper" wrote:

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