Formulas not calculating in some fields
 

Hello!

I've applied similar formulas to the same spreadsheet but some of the fields
are not calcuating correctly.

The value is always showing as 0 when i used below formula
When i tried to change the "Plan" to just "P". It will calculate partial of
the values
=SUMPRODUCT(--(ISNUMBER(SEARCH("IDS
SG",$F$24:$F$43))),--($G$24:$G$43="Plan"),$H$24:$H$43)

Whereas this formula is working fine:-
=SUMPRODUCT(--(ISNUMBER(SEARCH("IDS
SG",$F$24:$F$43))),--($G$24:$G$43="Actual"),$H$24:$H$43)

I've tried using Ctrl+ALT+F9 to force the recalculation but it's not working
still.
Any other alternatives i can explore?
--
judy goh

Formulas not calculating in some fields
 

And calculation is set to automatic?

In xl2003: Tools|Option|Calculation tab

If calculation is set to automatic, try this:

Select all the cells on the sheet (ctrl-a a few times)
Edit|replace
what: = (equal sign)
with: =
replace all

Excel will see that you've "changed" all the formulas and reevaluate each of
them.

judy wrote:

Hello!

I've applied similar formulas to the same spreadsheet but some of the fields
are not calcuating correctly.

The value is always showing as 0 when i used below formula
When i tried to change the "Plan" to just "P". It will calculate partial of
the values
=SUMPRODUCT(--(ISNUMBER(SEARCH("IDS
SG",$F$24:$F$43))),--($G$24:$G$43="Plan"),$H$24:$H$43)

Whereas this formula is working fine:-
=SUMPRODUCT(--(ISNUMBER(SEARCH("IDS
SG",$F$24:$F$43))),--($G$24:$G$43="Actual"),$H$24:$H$43)

I've tried using Ctrl+ALT+F9 to force the recalculation but it's not working
still.
Any other alternatives i can explore?
--
judy goh

--

Dave Peterson