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

[Nelson]

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

cheers


"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:420D770C.DE148362@netscapeXSPAM.com...
>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