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