Do you have errors in any of those fields in the raw data?

Do you have any numbers in the field that you're averaging?

evg1 wrote:

I am extremely new to pivot tables and trying to just get ave, max, and
min of a couple of columns ... I keep getting #DIV/0! errors and don't
know what the problem is. any ideas anyone???

--
evg1
------------------------------------------------------------------------
evg1's Profile: http://www.excelforum.com/member.php...o&userid=35043
View this thread: http://www.excelforum.com/showthread...hreadid=547887

--

Dave Peterson