| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating summary from a list | Excel Worksheet Functions | |||
| creating a summary sheet | Excel Discussion (Misc queries) | |||
| Creating a summary page in Excel | Excel Discussion (Misc queries) | |||
| Creating a summary Page | Excel Discussion (Misc queries) | |||
| Creating a list of worksheet names on a Summary PAge | Excel Worksheet Functions | |||
Linear Mode
