View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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