Totals of columns

M

Melvin Pauze

All of a sudden when trying to add or subtract line A, B,
C to Column D, Column D is not functioning. I have had no
trouble in the past. For example =SUM(H467+F468+G468-E468)
To total H468. H468 does not change when I substitute
any figure withing the brackets.
 
R

Ragdyer

Check to see if your calc is set to manual.

<Tools> <Options> <Calculation> tab,
And make sure Automatic *is* checked!
 
M

Mel Pauze

Thank you so much. It works.
-----Original Message-----
Check to see if your calc is set to manual.

<Tools> <Options> <Calculation> tab,
And make sure Automatic *is* checked!
--
HTH,

RD

---------------------------------------------------------- -----------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------- -----------------



.
Click to expand...
 
Top