Adding
 

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.

Adding
 

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


"Dig" wrote in message
...
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.

Adding
 

Hi and thanks for the reply.

They show True.

What does that mean?
Thanks

"David Biddulph" wrote:

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


"Dig" wrote in message
...
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.

Adding
 

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?
--
David Biddulph

"Dig" wrote in message
...

Hi and thanks for the reply.

They show True.

What does that mean?
Thanks

"David Biddulph" wrote:

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


"Dig" wrote in message
...
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.