I have an excel spreadsheet that is not showing the correct formula
calculation.

example...

I have three columns, I sum the first column then attempt to drag the
formula over for the next two (I have also tried pasting the formula) the
formula changes to show the proper cell reference in column 2 and 3 but shows
the result from column one. WTF!

Thanks for any insight you can offer