Adding

[Dig]

I have several columns that have totals. I created another area of the
spreadsheet where I wanted to use 2 of the totals from 2 columns.

I used the cells address (= I333) in D21 and (=J333) in E21. The showed the
totals as they should and if anything changes in the respective columns these
cells adjust accordingly.

Now I wanted to add these add these (=D21+E21), I got $0. I have done this a
zillion times but I can't get it to give me a total.

What is going on here?? Why can't I add the two cells that are referencing
the other cells?
Any help appreciated.

 

[David Biddulph]

Perhaps your input cells contain text, rather than numbers? What do
=ISNUMBER(D21) and =ISNUMBER(E21) show you?

 

[Dig]

Hi and thanks for the reply.

They show True.

What does that mean?
Thanks

 

[David Biddulph]

That means they are numbers, not text, so it isn't obvious why you are
seeing zero when you add them together. What numbers are in D21 and E21?