At times it may be helpful to sum exported data. This can be done by using the SUM function in Excel.
1. Export the file as a CSV (comma separated values) file. 2. Open the file in Excel. 3. Highlight the amount column in Excel. 4. Select Format, Cells. 5. On the number tab, select a number format such as Number, Currency, etc. 6. Click OK. 7. Select the last open cell in this column and select to insert an AutoSum (sigma button on the toolbar). Tab out when the formula shows. The sum of that column should now show.