I have been killing myself with this problem for 2 days now, and I give
up. I can't solve this myself. It seems that Excel works differently
each time I use it. This is my situation:

I have a .csv file w/ 20k records.
I have a pivot table report that reads the .csv as the source.
In the pivot, I need calculate the average for one of the columns in
the .csv
The problem is that 90% of the records have a 0 as the value for that
column.
I dont want to average the 0's into the average.

When I take out the zeros, i get a #DIV/0 error.

I have successfully been able to make this calculation twice, but it
seems very inconsistent, as if Excel were working differently each time
I do it. Can someone provide some insight on this??

There has to be an easy way of doing this.... I appreciate the help...


--
dylankrapf
------------------------------------------------------------------------
dylankrapf's Profile: http://www.excelforum.com/member.php...o&userid=26067
View this thread: http://www.excelforum.com/showthread...hreadid=394035