View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
huskybytes
 
Posts: n/a
Default EXCEL2000 trouble with SUM function recalculating on new data ent

I have a Sum function at the end of each row. When I enter the new monthly
number, it doesn't recalculate. F9 has no effect. If I change Sum (B1:m1)
to
=B1+C1+D1... it calculates correctly. I checked the data type to be Number,
0 Decimals for all cells.