SUM isn't working

[Guest]

I'm doing something wrong while trying to add a column of numbers, and have
the SUM reflect the changes to the values of those numbers. I've used this
tool before and it's been fine.

However, for some reason the SUM cells won't refresh when new values are
added in the cells above it.

Example: Let's say that B2 thru B4 various values; B5 has =SUM(B2:B4)
B2 = $5.00
B3 = $6.00
B4 = 0
B5 = SUM(B2:B4) = $11.00

If I change B4 to $8.00, B5 should automatically change to $19.00, but it
won't. It just stays at $11.00.

This is now consistently happening in all my Excel worksheets. Help!! I
can't figure out what I'm doing wrong. Thanks.

 

[Ken Wright]

Tools / Options / Calculation / Change Manual to Automatic

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

Thank you so much! You've made my day.

Dooley

Tools / Options / Calculation / Change Manual to Automatic

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Ken Wright]

LOL - You're very welcome - That one can be very frustrating if you don't
know whats going on

Regards
Ken..........................