Exporting data to Excel: SUM not working in a column(field)

Hello,

For the debit memo file, when I download the Excel report for all submissions in the Inbox, the sum function does not correctly add up the values in the unfiltered column titled original chargeback value.  Highlighting all the values does not correctly sum either.  Is there a way to fix this?

Thanks!

That is happening because some of the values contain the dollar sign ($), so they are read as text, nor as numbers. You would need to format/convert the whole column to numbers. 

I believe that this guide would help: https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885

Let us know if you have more questions.