Sumproduct formula

[xxsalahxx]

Hello I am using the sumproduct below and this does not seem to be working.
I2 - I500 has a lot of text in the cells however some cells are blank and I don't want to count these, can someone help with this formula?


=SUMPRODUCT(('Q1 Physical'!C2:C500>=Sheet1!B4)*('Q1 Physical'!C2:C500<=Sheet1!B5)*('Q1 Physical'!E2:E500=Sheet1!A7)*ISTEXT('Q1 Physical'!I2:I500))

Thank you in advance for any help I can receive.

 

[BlueHornet]

Try adding parentheses as shown here:
=SUMPRODUCT((('Q1 Physical'!C2:C500)>=Sheet1!B4)*(('Q1 Physical'!C2:C500)<=Sheet1!B5)*(('Q1 Physical'!E2:E500)=Sheet1!A7)*ISTEXT('Q1 Physical'!I2:I500))

 

[xxsalahxx]

Try adding parentheses as shown here:
=SUMPRODUCT((('Q1 Physical'!C2:C500)>=Sheet1!B4)*(('Q1 Physical'!C2:C500)<=Sheet1!B5)*(('Q1 Physical'!E2:E500)=Sheet1!A7)*ISTEXT('Q1 Physical'!I2:I500))

Thank you!!