why do I get zero when I add up excel cells that contain formulas?

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.

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!

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.

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.

thanks for your offers of help.

I'm glad you got it solved.

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

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History