Forum Discussion

Bill Claman's avatar
Bill Claman
Copper Contributor
Apr 24, 2018

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 pattern.  Any suggestions?

Formulas & Functions
Need Help

1 Reply

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor
    Apr 24, 2018

    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.