ExcelBanter - SUM Total

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM Total (https://www.excelbanter.com/excel-worksheet-functions/17798-sum-total.html)

Joe

SUM Total

I am having trouble tracking down a solution for an issue with Excel.

I am using a sum formula that will only update a 'total' when I hit the save
icon? In other words, it wont update the total when I change a value of a
cell in the formula range.

Any ideas?

Steve R

Joe
Check your calculation setting:
Tools, Options, Calculation

Steve

"Joe" wrote in message
...
I am having trouble tracking down a solution for an issue with Excel.

I am using a sum formula that will only update a 'total' when I hit the
save
icon? In other words, it wont update the total when I change a value of a
cell in the formula range.

Any ideas?

Joe

Thanks, Steve. That was it!

"Steve R" wrote:

Joe
Check your calculation setting:
Tools, Options, Calculation

Steve

"Joe" wrote in message
...
I am having trouble tracking down a solution for an issue with Excel.

I am using a sum formula that will only update a 'total' when I hit the
save
icon? In other words, it wont update the total when I change a value of a
cell in the formula range.

Any ideas?

All times are GMT +1. The time now is 05:40 AM.