Help with Avg. formula

Giganews Newsgroups
Subject: Help with Avg. formula
Posted by:  bill (sarahbi…@charter.net)
Date: Fri, 10 Oct 2003

Hi,

I have an xl sheet like below, and hope someone can
provide a formula to get this average.

M    T    W      T      F
-------------------------------
50    33                          daily avg needed here

The part I am having trouble with is, If Monday and Tues
have a value, but the rest of the week does not, I want the
average to calculated for only the 2 days where there is
data, not the average over the whole week. Could someone
please help me with a formula for this???

thanks in advance....Bill

Replies