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