Sorry if already here. Average HELP!!!
tjcosmo,
I should have added for Cell "I1" and Cell "J1":
Click and Fill down the column with the formulas for every row of employee
names.
--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))
"Rich/rerat" wrote in message
...
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
|