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

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

Hi,

I'm not sure what your question is: Your formula will work although it
could be shorter:

=IF(SUM(P3:S3)=0,"",AVERAGE(P3:S3))

If your asking how should it look when referencing another sheet then

=IF(SUM(Sheet2!P3:S3)=0,"",AVERAGE(Sheet2!P3:S3))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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