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?

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