ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Automatic Adding (https://www.excelbanter.com/new-users-excel/172535-automatic-adding.html)

Help newbie

Automatic Adding
 
Not sure if i used the right formula to begin with to calculate the sum of 7
different cell ( D5-J5 ) ...i just went to Math , sum, then typed in
D5+E5+F5....and so on.
But now i want to have the total amount figured out automatically as hours
change per week...is that possible??

Roger Converse[_2_]

Automatic Adding
 
Hello,

You can use

=sum(D5:J5)

for the calculation as opposed to D5+E5....

Check under Tools | Options | Calculations

Is Automatic checked?

HTH
Roger

"Help newbie" wrote:

Not sure if i used the right formula to begin with to calculate the sum of 7
different cell ( D5-J5 ) ...i just went to Math , sum, then typed in
D5+E5+F5....and so on.
But now i want to have the total amount figured out automatically as hours
change per week...is that possible??



All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com