Sumproduct inside a sumproduct?

[charliew]

I am trying to sum the products of a cell in a few sheets, based on various arrays...needless to say, it wont work...

this is what i've got:

=SUMPRODUCT((CW!$B$2:$B$1000="Ext")*(CW!$I$2:$I$1000="RH")*(INT(CW!$D$2:$D$1000)=A85))*SUMPRODUCT((TC!$B$2:$B$1000="Ext")*(TC!$I$2:$I$1000="RH")*(INT(TC!$F$2:$F$1000)=A85))

the bold bit is on the other sheet and this is where i think im going wrong...???

thank you in anticipation!!!

 

[charliew]

Aladin, I have solved the issue! i used your =ISNUMBER formula on all cell in the range and out of 700 cells just 1 was FALSE! i sorted this to be numerical and the formula worked!!!

 

[Aladin Akyurek]

Aladin, I have solved the issue! i used your =ISNUMBER formula on all cell in the range and out of 700 cells just 1 was FALSE! i sorted this to be numerical and the formula worked!!!

Great. Thanks for the update.