Use
=Sum(F1,F2,F3..)/Count(F1,F2,F3...)
Blank cells will add nothing to the Sum total, and Count will only count the
cells with numbers; hence you can obtain the average for the numbered cells.

Paul


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
Hi all,

I have a pivot table where I created a calculated field that averages
three
of the fields in the pivot table. My problem is that it averages the
"blank"
(which are created from blank fields in the source data) fields instead of
ignoring them. How can I average the fields in a Pivot Table and not
include
the blanks in the average?