Creating a summary page
 

Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

Creating a summary page
 

If the formula in the other sheet's cell that you're linking is returning a
"correct" zero, then you should also be getting a zero in the linked cell??
Perhaps it's more a case that your calc mode's inadvertently set to manual.
Do a quick check: Click Tools Options Calculation tab Check "Automatic"
OK. Does the linked cell now return correctly (presumably the sum over in
the other sheet is a non-zero value)?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

Creating a summary page
 

You could modify your formula.

Formulas like:
='sheet 2!a1

would become
=if('sheet 2!a1="","",'sheet 2!a1)



Pascale wrote:

Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

--

Dave Peterson

Creating a summary page
 

I have done the proposed steps, but it is still not working it gives me a
zero, and the other cell is a sum like this:
=SOMME(AZ22;AZ27;AZ43) I set to automatic also.

TK

"Max" wrote:

If the formula in the other sheet's cell that you're linking is returning a
"correct" zero, then you should also be getting a zero in the linked cell??
Perhaps it's more a case that your calc mode's inadvertently set to manual.
Do a quick check: Click Tools Options Calculation tab Check "Automatic"
OK. Does the linked cell now return correctly (presumably the sum over in
the other sheet is a non-zero value)?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

Creating a summary page
 

What is the result from this formula?
=SOMME(AZ22;AZ27;AZ43)

Can you also post your link formula?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
I have done the proposed steps, but it is still not working it gives me a
zero, and the other cell is a sum like this:
=SOMME(AZ22;AZ27;AZ43) I set to automatic also.

TK

Creating a summary page
 

I did this modification but it is still giving me a zero

"Dave Peterson" wrote:

You could modify your formula.

Formulas like:
='sheet 2!a1

would become
=if('sheet 2!a1="","",'sheet 2!a1)



Pascale wrote:

Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

--

Dave Peterson

Creating a summary page
 

The sum of the formula is :122,395.00 $
My link formula is :
=Données!AZ44
Answer is 0
I also tried this formula:
=SI(Données!AZ44="";"";Données!AZ44)
Answer is 0
"Max" wrote:


TK
What is the result from this formula?
=SOMME(AZ22;AZ27;AZ43)

Can you also post your link formula?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
I have done the proposed steps, but it is still not working it gives me a
zero, and the other cell is a sum like this:
=SOMME(AZ22;AZ27;AZ43) I set to automatic also.

TK

Creating a summary page
 

=Données!AZ44
um, maybe just try a quick check ...
Are you pointing to the correct* cell in the above?
*the one in the other sheet with the result: 122,395.00 $

If the above is not it, can you upload
& post a direct link to your sample
Use: http://www.freefilehosting.net/
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Creating a summary page
 

I checked all is ok, so I up loaded the file

"Max" wrote:

=Données!AZ44
um, maybe just try a quick check ...
Are you pointing to the correct* cell in the above?
*the one in the other sheet with the result: 122,395.00 $

If the above is not it, can you upload
& post a direct link to your sample
Use: http://www.freefilehosting.net/
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Creating a summary page
 

Link?

You need to copy and paste the link into your reply here

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Creating a summary page
 

I checked all is ok, so I up loaded the file

Or you really meant all is ok, so you didn't upload the file??

If all is ok, pl tell us what was the issue and how did you resolve it over
there?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Creating a summary page
 

If you really want to hide the 0's:

=if('sheet 2!a1=0,"",'sheet 2!a1)

If your =sum() formula is returning 0 and you think it's wrong, maybe your cells
aren't really numbers:

=SOMME(AZ22;AZ27;AZ43)
Reformat AZ22 as General (or anything but text) and reenter the value
same with AZ27 and AZ43

Or change your formula to:
=AZ22+AZ27+AZ43



Pascale wrote:

I did this modification but it is still giving me a zero

"Dave Peterson" wrote:

You could modify your formula.

Formulas like:
='sheet 2!a1

would become
=if('sheet 2!a1="","",'sheet 2!a1)



Pascale wrote:

Hello,

I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.

Why is that? and how can i fix it?

Regards

--

Dave Peterson


--

Dave Peterson

Creating a summary page
 

Hi i didnt realize I didnt do the upload correctly..
So no it is still not working, so let me try the upload again.
http://www.freefilehosting.net/download/3dld5
<a href="http://www.freefilehosting.net/files/3dld5"Dépense
Videotron1.xls</a
Dépense Videotron1.xls
"Max" wrote:


Thank you
I checked all is ok, so I up loaded the file

Or you really meant all is ok, so you didn't upload the file??

If all is ok, pl tell us what was the issue and how did you resolve it over
there?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Creating a summary page
 

In sheet: Données
Correct all your circular formulas in col AZ
Eg in AZ11: =SUM(AN11:BC11) is circular
It should be corrected to:
=SUM(AN11:AY11,BA11:BC11)
Likewise for all the rest of circular errors in AZ13, AZ15, etc
Once corrected, your link formula will work normally
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---