Tried everything - cannot get excel to sum!

New Contributor

Desperate -- i've tried all tips I've seen, not sure what to do anymore. I am getting zeros in my pivot table from the amount row -- i've made sure it's not text and the spreadsheet isn't set to manual calculate. what am I missing? thank you so much.

3 Replies
best response confirmed by las751875 (New Contributor)

@las751875 All your amounts are texts. Transformed them to numbers with "Text to columns". Now all works.


Is it weird to say I love you? Because I love you!
I tried the text to columns too, several times. Delimited > tab > general > finish. What did I do wrong? I am really baffled. I cleared formatting multiple times, went through each cell individually and pressed enter to make sure everyone was number...Truly, don't get it.
Enormously grateful!!!