Maybe you could use a helper column:

=if(a2=0,0,1)

and then include that in the pivottable as sum???

janssenchoy wrote:

Is there some way to get a pivottable to display a count of all non-zero
entries? I'd want to use a pivottable over subtotaling or a combination
of sorting and counta, due to the amount of categories I have to split
items into (~approx 200).

--
janssenchoy
------------------------------------------------------------------------
janssenchoy's Profile: http://www.excelforum.com/member.php...o&userid=32805
View this thread: http://www.excelforum.com/showthread...hreadid=526227

--

Dave Peterson