Cells showing numbers other than the calculation result

S

Swing

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...
 
N

Niek Otten

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

| 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
 
M

Max

.. 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
 
B

Bernard Liengme

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(.......) ?
 
Top