| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting pivot tables
I am trying to create a SUM IF formula from a pivot table in a different
worksheet, but the column data field will not be reconised as a number format I have tried right click-format cell-number but it still does not work any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting pivot tables
If you're trying to summarize data from the pivot table, it may be
easier to create another pivot table, based on the first one. Then, create a layout that just shows the summarized data. Caz wrote: I am trying to create a SUM IF formula from a pivot table in a different worksheet, but the column data field will not be reconised as a number format I have tried right click-format cell-number but it still does not work any ideas? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot tables and dynamic columns | Charts and Charting in Excel | |||
| Excel 97 Question (Pivot tables) | Excel Discussion (Misc queries) | |||
| synchronising pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Tables: need to customize formatting | Charts and Charting in Excel | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Linear Mode
