View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default 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.