View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default formulas are not repeating across the board.

I never had any problems


--
Regards,

Peo Sjoblom



"Ronald Dodge" wrote in message
...
F9 may or may not work. I have had too many issues of F9 not working
properly as it was intended to work. Shift-F9 (Sheet level) or
Alt-Ctrl-F9 (Forced full calculation) does work. This last one has more
or less replaced the F9 key as it makes sure everything gets calculated.

Ronald R. Dodge, Jr.
Master MOUS 2000

"Peo Sjoblom" wrote in message
...
First of all, replace the formula with

=SUM(B2:D2)

however that won't affect your problem but you should not use SUM in the
way you used it so either B2+C2+D2 or the simpler SUM(B2:D2). What
happens if you press F9?


--
Regards,

Peo Sjoblom




"Sharna" wrote in message
...
The formulas that I have put into the program, Example: =sum(b2+c2+d2)
is not
adding my numbers up in the designated cells. It is like the program has
been
contaminated or locked up some how. All my files that I use excel with
are
not responding.