Help changing Pivot table from Count to Sum

[rosscortb]

Hello All,

I have the following code which brings out the count on a pivot table, I read you can't just do xlSum so I found some other code online ( at the bottom)'Commented out, which I ran as a seperate macro which does change it to Sum but the results are just Zeros. Any Ideas?
Thanks

Ross

Please Login or Register  to view this content.

[xlnitwit]

You can do a sum in the code simply by replacing xlCount with xlSum. If Sum returns 0, then your data is actually stored as text.

[rosscortb]

I right clicked on total absence days and format of the cells is number. If I just do a pivot table manually it works.

[xlnitwit]

Cell format does not necessarily reflect its content. Are you using exactly the same source range for the manual pivot as for the code created one? If so, can you post a sample workbook for testing?

[rosscortb]

Managed to do it by adding. Thanks for your help.

Please Login or Register  to view this content.