Calculate Average and dispaly in another worksheet

  • Thread starter Thread starter Flipper
  • Start date Start date
F

Flipper

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)))
 
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...
 
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))
 
Back
Top