Excel problem

bmansfield · 07-05-2008, 03:24 PM

I am working on a budget in Excel 2003. I am trying to pick up the subtotals from various sections of the budget to come up with total direct costs. No matter what method I use to get a total, the total cell ends up blank. Even if the cell shows the formula, the total amount does not appear. Help please!

mont · 07-05-2008, 05:47 PM

Hi, I'm not a tech, but I use Excel a lot.

Excel will do this if it detects a circular reference. It might be worth bringing up the circular reference toolbar to see if this is your problem.

Sorry if you already tried this,
mont

MrChooks · 07-05-2008, 06:14 PM

Sorry if this sounds a bit too obvious

- but have you checked that the target cell (where the formula lives and where you want your answer) hasn't been inadvertently formatted as text of some other pesty option.

You can check by just doing a "1+1=" in that cell - if it comes out at 2 - then that's NOT the problem - but with XL - anything's worth a try

**gistek** · 07-07-2008, 08:22 PM

Also, make sure you didn't put an "=" where you should have a "+"
If False is set to not show, you'll end up with an empty cell.

One other possibility is text color. If the text and background colors are the same, the cell will appear empty unless you highlight it.

07-05-2008, 03:24 PM	#1 (permalink)
bmansfield Registered User Join Date: Jul 2008 Posts: 1 OS: win98	Excel problem I am working on a budget in Excel 2003. I am trying to pick up the subtotals from various sections of the budget to come up with total direct costs. No matter what method I use to get a total, the total cell ends up blank. Even if the cell shows the formula, the total amount does not appear. Help please!

07-05-2008, 05:47 PM	#2 (permalink)
mont Registered User Join Date: Jul 2008 Posts: 4 OS: vista	Re: Excel problem Hi, I'm not a tech, but I use Excel a lot. Excel will do this if it detects a circular reference. It might be worth bringing up the circular reference toolbar to see if this is your problem. Sorry if you already tried this, mont

07-05-2008, 06:14 PM	#3 (permalink)
MrChooks Gearhead Join Date: Apr 2008 Location: Sydney, Australia Posts: 613 OS: Windows XP Home SP 3 My System	Re: Excel problem Sorry if this sounds a bit too obvious - but have you checked that the target cell (where the formula lives and where you want your answer) hasn't been inadvertently formatted as text of some other pesty option. You can check by just doing a "1+1=" in that cell - if it comes out at 2 - then that's NOT the problem - but with XL - anything's worth a try

07-07-2008, 08:22 PM	#4 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,904 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Excel problem Also, make sure you didn't put an "=" where you should have a "+" If False is set to not show, you'll end up with an empty cell. One other possibility is text color. If the text and background colors are the same, the cell will appear empty unless you highlight it. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team