tjcosmo,

Cell:
A1:

Type Employee Name

B1 through H1:

Type Sunday to Saturday

I1:

Type or Copy/Paste the following formula in the cell, then Press Enter

It will give the average based on the days worked.
=IF(COUNT($B2:$H2)=0,0,AVERAGE($B2:$H2))

J1:

If you want to have the daily average in a week even if the person doesn't
work every day. You can Type or Copy/Paste the following formula in the
cell, then Press Enter
=IF(COUNT($B2:$H2)=0,0,SUM($B2:$H2)/7)

You can use an "X" (w/o quotes) for days off, it should not alter the
results.

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"tjcosmo" wrote in message
...

So I'm a restaurant manager and we track our server PPA's. which is a
fancy thing for server check amounts. I want to track each server each
week. Here's the thing, each server does not work everyday. So one
server might work mon/wed/fri. So i need a formula that averages the
amounts only when a value is imputed. But it needs to be already setup
so when i put in the days averages it recomputes it again. and if a
server works another day like sat it would then average 4 days instead
of 3. Is ther anyway to do this?


thanks so much




--
tjcosmo