| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells showing numbers other than the calculation result
I'm not sure if anybody encountered this before.
I am using the Sum(IF) combination to sum up numbers with 3 different criteria. The calculated cells only show either "0" or "215" while I go into the Fx formula box, it calculates correctly. At first, I was thinking about there might be something wrong with my format setting. I did try....doesn't work. Does it relate to my criteria setting?? as I am doing some logical tests related to calendar dates. Would appreciate if anyone gives me any hint in solving this... -- Thanks, Swing |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells showing numbers other than the calculation result
Hi Swing,
Format your cells as Number AND re-enter the numbers (F2, ENTER). Just reformatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "Swing" wrote in message ... | I'm not sure if anybody encountered this before. | I am using the Sum(IF) combination to sum up numbers with 3 different | criteria. The calculated cells only show either "0" or "215" while I go into | the Fx formula box, it calculates correctly. | At first, I was thinking about there might be something wrong with my format | setting. I did try....doesn't work. | Does it relate to my criteria setting?? as I am doing some logical tests | related to calendar dates. | Would appreciate if anyone gives me any hint in solving this... | | -- | Thanks, | Swing |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells showing numbers other than the calculation result
.. Sum(IF) combination
You need to array-enter the above formula, ie press CTRL+SHIFT+ENTER (instead of just pressing ENTER) Try it again, click inside the formula bar, then press CTRL+SHIFT+ENTER -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Swing" wrote: I'm not sure if anybody encountered this before. I am using the Sum(IF) combination to sum up numbers with 3 different criteria. The calculated cells only show either "0" or "215" while I go into the Fx formula box, it calculates correctly. At first, I was thinking about there might be something wrong with my format setting. I did try....doesn't work. Does it relate to my criteria setting?? as I am doing some logical tests related to calendar dates. Would appreciate if anyone gives me any hint in solving this... -- Thanks, Swing |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells showing numbers other than the calculation result
What is your formula?
"Swing" wrote: I'm not sure if anybody encountered this before. I am using the Sum(IF) combination to sum up numbers with 3 different criteria. The calculated cells only show either "0" or "215" while I go into the Fx formula box, it calculates correctly. At first, I was thinking about there might be something wrong with my format setting. I did try....doesn't work. Does it relate to my criteria setting?? as I am doing some logical tests related to calendar dates. Would appreciate if anyone gives me any hint in solving this... -- Thanks, Swing |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells showing numbers other than the calculation result
Would you like to share the formula you are using?
Are you completing the formula with Shift+Ctrl+End (assuming it is of form =SUM(IF(.......) ? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Swing" wrote in message ... I'm not sure if anybody encountered this before. I am using the Sum(IF) combination to sum up numbers with 3 different criteria. The calculated cells only show either "0" or "215" while I go into the Fx formula box, it calculates correctly. At first, I was thinking about there might be something wrong with my format setting. I did try....doesn't work. Does it relate to my criteria setting?? as I am doing some logical tests related to calendar dates. Would appreciate if anyone gives me any hint in solving this... -- Thanks, Swing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| showing several cells result in one cell | Excel Discussion (Misc queries) | |||
| Sorting Cells on letters and numbers and placing result in one of 3 columns | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
