I am not sure what you are doing with the 'MATCH' as I have never used it. DO I need it? (presuming I don't care about neatness for now)Quote:
Originally Posted by xld
I am not sure what part of my
in particular you are correcting? Could you maybe boldface it?Code:
=SUMPRODUCT((ISNUMBER( 'Cold Difference'!$1:$4))*('Cold Difference'!$1:$4<=Charts!A1)* ...
... (('Cooling Type'!$A$1:$A$4="C")*('Cooling Type'!$B$1:$B$4="T")))
I have the condition:ANDed with the conditionCode:(ISNUMBER( 'Cold Difference'!$1:$4))
ANDed with the resultant of the two conditionsCode:('Cold Difference'!$1:$4<=Charts!A1)
Updated sample file attached. You can see that on the "Charts" sheet, everything works out.Code:(('Cooling Type'!$A$1:$A$4="C")*('Cooling Type'!$B$1:$B$4="T"))