Adding cells that contain formulas

August 31, 2011 at 13:53:45
Specs: Windows 7
why do I get zero when I add up excel cells that contain formulas?

See More: Adding cells that contain formulas

Report •

#1
August 31, 2011 at 14:01:23
What formulas do the cells contain?

If they are returning something that Excel considers to be text, then they will sum to 0.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 31, 2011 at 14:12:24
I have a large corporate budget worksheet that is linked to 10 backup sheets. The formulas in the cells that I'm trying to add are sums of the amounts that come from the linked worksheets. For example - I have revenues for Division A that are totals of the revenues coming from the budget sheet of Division A. The revenues are coming thru to the corporate budget thru linked cells. When I add the totals on the total corporate sheet I get zero. I hope this makes sense!

Report •

#3
August 31, 2011 at 14:14:56
Can you please post an example of one of the formulas?

Keep in mind that we can't see your workbook from where we're sitting, so it's kind of tough to offer solutions without some more details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
August 31, 2011 at 14:43:17
OK, well I replaced the formulas with hard coded numbers, then redid the formulas and now I can add the cells up and get proper totals. Don't know what is going on, but when the formulas were in there originally, they were being seen as text.

I'm not crazy about Windows 7 - very squirrely.


Report •

#5
August 31, 2011 at 14:43:39
thanks for your offers of help.

Report •

#6
August 31, 2011 at 20:18:21

Report •

Ask Question