Reference to cell returns zero

Question

Hi,

I have a workbook with some sheets. some of them feed a Summery sheet and I have some summerize cells that I can see the total of a range of cells. When I take an empty cell and want to refer it to one of the summerize fields I get zero.

Any suggestions?

thanks a lot in advance

Answer 1

Hi Mike,

I will give an example:

In cell D22 i have: =sum(D2:D20) and I can see the total amount properly. D2 till D20 also retreive information from other sheets.

I go to an empty cell (E22) and write: =D22. I get 0 instead of the sum I see in cell D22.

You see my problem?

Answer 2

Hi,

I assume you want to return an empty cell if th referenced cell is empty, try this

=IF(LEN(Sheet2!A1)>0,Sheet2!A1,"")

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 3

Hi Max,

What is the cell format of the cell E22?

If it is rounding to even thousands, that could explain the 0.

Answer 4

> .. I go to an empty cell (E22) and write: =D22. I get 0 instead of the sum I see in cell D22

One guess, perhaps there's a circular ref error in your sheet/book which has stopped calcs

Answer 5

Hi Mike,

I will give an example:

In cell D22 i have: =sum(D2:D20) and I can see the total amount properly. D2 till D20 also retreive information from other sheets.

I go to an empty cell (E22) and write: =D22. I get 0 instead of the sum I see in cell D22.

You see my problem?

Hi,

I don't understand this, you have data laid out like this

D2	1
D3	2
D4	3
D5	4
D6	5
D7	6
D8	7
D9	8
D10	9
D11	10
D12	11
D13	12
D14	13
D15	14
D16	15
D17	16
D18	17
D19	18
D20	19
D22	190	0

It doesn't (Shouldn't) matter how those values arrive in D2 to D20. In D22 you have the formula

=SUM(D2:D20) and as in my example it's returning the sum of those cells

You now seem to be saying that you enter the formula =D22 into E22 and instead of returning the value(190 in my example) it returns zero. Have I understood correctly?

---

If this post answers your question, please mark it as the Answer.

Mike H