Hello!
So I have a pivot table to calculate how many hours went to each job. When it shows the count, it calculates properly, but when I change it to sum the number of hours it pulls up 0. The hours field is formatted as Number. Not sure why it won't sum the hours. Any ideas on how to fix this would be greatly appreciated.
Just as an FYI, we recently transferred over to Excel 365 from Excel 2013 on Windows 7.
Data.JPG
Count.JPG
Sum.JPG
From the fact that all your Hours values are left aligned, I think they are stored as text. Make sure the source cells are not formatted as Text, then copy a blank cell, select all the hours cells, then Paste Special, and choose Values and Add. Then refresh the pivot table.
Rory
I did change the format of the column to be number but they didn't update I suppose? I went and I used the replace function to update the numbers and they realigned and now it works. I'm not sure why it didn't update but its working properly now. Thanks!
Changing the format doesn't update the contents of the cell. The copy/paste method is a quick way of doing them all in one go, just for future reference.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks