I have a pivot table in MS Excel based on about 32000 rows of data. 
In the layout part of the MS Excel pivot wizard, there is a list of
data elements.  Double clicking the field reveals a list of functions.
 I am looking for a function that excludes null values from my
average.  I am the executive receiving the report, and I need to get
this done today.  My analyst is out of the office and I cannot reach
him.  I know my way around pivots a bit, but I cannot figure out how
to do this simply.  I need a fast fix because I don't have more than
15-30 minutes available to fix this.  If you have a fast fix let me
know; otherwise my analyst will fix tomorrow but I will be late with
this report.  Thanks, Chris

Are you sure that the average function used through Pivot tables
doesn't already ignore NULL values?  Or do you want it to ignore zero
values?  If you test a pivot table with less records but a few null
values, I think it will show that NULL values ARE already being
ignored.

Ken

Ken is right about pivot ignoring null values.  The analyst has added
some kind of extra step, and is showing a page in the file that
includes null values in the count for the denominator.  However, the
page is some kind of values-output only from which I cannot derive
sources or formulae.  I'll have to wait for my analyst.  The extra
step is some other process that is including null values (I do not
mean zeroes).  Thanks, chris