J
judy
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?
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?