Skip to Content
0
Former Member
Jul 17, 2008 at 06:16 PM

Weighted Averages - How Do I Exclude Empty Cells?

37 Views

Having issues here...

(empty)

100

(empty)

33.3

The first 3 valuess represent weeks of the months in July 08. The final row calculates the weighted average. The weighted average shows 33.3, but it should really show 100. It appears the formula is using the empty values in the equation.

Following is the cell for each week: "PTS - FC LS"

Follwing is the cell for the weighted average field: "Denominator - FC LS" * "PTS- FC LS" / "Denominator - FC - LS"

How do I get the formula to disregard the empty cells in the weighted average calculation?

Thanks in Advance,

Ryan