Pivot Table

T

Té

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?
 
J

Jim Thomlinson

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...
 
Top