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
|