There is no way to avoid counting the zeros. What I would do would be to add
a new column to my source data something like
=if(b2=0,0,1)
You can sum up that column to get a count that excludes the zeros...
--
HTH...

Jim Thomlinson


"Té" wrote:

Im creating a pivot table, and I changed the field settings to count. Is
there anyway I can prohibity 0 from being counted as a number without
manually deleting all the zeros in the worksheet?