ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Getting total (https://www.excelbanter.com/setting-up-configuration-excel/162469-getting-total.html)

JL

Getting total
 
How do I get the row of numbers to add up to a total for the total box on an
expense statement?

It won't let you put a number in that box it says Excel has an equation and
figures it out by itself...But it never does?

JLatham

Getting total
 
#1: Make sure the formula refers to the correct range of values to be totaled.

#2: Check Tools | Options and on the [Calculation] sheet and make sure that
"Automatic" calculation is selected.

"JL" wrote:

How do I get the row of numbers to add up to a total for the total box on an
expense statement?

It won't let you put a number in that box it says Excel has an equation and
figures it out by itself...But it never does?



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

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