Forum Discussion
Sum with reference
I have a spreadsheet with 50k+ rows. When I "sum" an amount column, I get different results if the spreadsheet is sort differently. I would expect the results to be the same regardless of the sort...
Hi
While using SUM function,
1. Put $ symbol in formula (eg =SUM(C2:C200) will be =SUM($C$2:$C:$200)
2. Try to do SUM entire column =SUM(C:C). Make sure you dont have any subtotals in Column C and Dont put this formula in "Column C".
3. Use Pivot table for SUM.