Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |