Pivot Table to Ignore N/As
 

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

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 wrote:

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

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

cheers


"Dave Peterson" wrote in message
...
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 wrote:

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