Pivot Table to Ignore N/As

[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

 

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

 

[Nelson]

Thanks Dave, that's what we figured we had to do.

cheers