Excel SUMPRODUCT with blank cells

Question

I'm using SUMPRODUCT with COUNTIFS but when there are blank cells it show error. my formula is:

 =SUMPRODUCT((O16:O63="Low")/COUNTIFS(O16:O63,O16:O63,I16:I63,I16:I63))

Answer 1

Try :

=SUMPRODUCT((O2:O16="Low")/COUNTIFS(O2:O16,O2:O16&"",I2:I16,I2:I16&""))