Pivot Table to Ignore N/As

N

Nelson

Hi, Does anyone know if it is possible to get a pivot table summary to
ignore N/As within a table when summing the data?

Nelson
 
D

Dave Peterson

I don't.

Maybe you could clean them up in the original data (if those cells are a
formula):

=if(iserror(yourformula),0,yourformula)

Or even use another column:

=if(iserror(b2),0,b2)

Then use that other column in the pivottable.
 
Top