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.
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.