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

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

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

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

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