| 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
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 |
|
#3
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 |
|
#4
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 |
|
#5
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 |
|
#6
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 |
|
#7
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 |
|
#8
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 |
|
#9
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 --- |
| 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 | |||
Hybrid Mode
