Creating a summary page

  • Thread starter Thread starter Pascale
  • Start date Start date
P

Pascale

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
 
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
Click to expand...
the other sheet is a non-zero value)?

---
 
You could modify your formula.

Formulas like:
='sheet 2!a1

would become
=if('sheet 2!a1="","",'sheet 2!a1)
 
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
 
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
:


TK
 
=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/

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

---
 
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
 
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

---
 
Back
Top