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