Formula looks right but shows incorrect result
 

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

Formula looks right but shows incorrect result
 

Perhaps you should post your fing formula. Probably need to adjust $

--
Don Guillett
SalesAid Software

"Pants00" wrote in message
...
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

Formula looks right but shows incorrect result
 

One thought. Perhaps calc mode is inadvertently set to manual? Press F9, does
it now compute properly? To check/change calc mode, click Tools Options
Calculation tab. Options are there. Ensure Automatic is checked OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pants00" wrote:
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