Sorry if already here. Average HELP!!!
This is a good question.
Set up a seven day table. Pick any starting day you like. Assign a
row or column for each server. Say Ellen's name is in A1 and the
weekly values are in A2 thru A8. In A9 enter:
=AVERAGE(A2:A8)
It is important, that in A2 thru A8, to leave the value blank rather
than zero for non-working-days. AVERAGE() will ignore blank values.
|