ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum not showing up (https://www.excelbanter.com/excel-discussion-misc-queries/239244-sum-not-showing-up.html)

Jan

Sum not showing up
 
I'm using the sum formula (in Office 2003) that adds up the numbers in
different cells (ie: a4, d4, h4, k4, etc). In the cell where the formula is,
the added number is not showing up. When I click within the formula in the
formula bar & hit enter, the number does show up. Once I've added another
number, it goes back to not showing up. I've had another spread sheet for
years using this same method which has always worked & now it's not working
either.

Gary''s Student

Sum not showing up
 
Tools Options Calculation Automatic
--
Gary''s Student - gsnu200860

Jan

Sum not showing up
 
Thank you! I knew it had to be something simple.

"Gary''s Student" wrote:

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200860



All times are GMT +1. The time now is 01:22 PM.

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