Hi Team
Need your help in Sumproduct formula.
In Column J I want to include two Criteria. {"Pending" and blank Cells), How to include blank cell as well.
=SUMPRODUCT(ISNUMBER(MATCH($H$2:$H$31,{"India","USA","Canada"},0))
*ISNUMBER(MATCH($I$2:$I$31,"20",0)))
*ISNUMBER(MATCH($J$2:$J$31,{"Pending",""<>""&"*"},0)) Here in this line I am trying to include Pending or blank cells.
Thanks
mg
Need your help in Sumproduct formula.
In Column J I want to include two Criteria. {"Pending" and blank Cells), How to include blank cell as well.
=SUMPRODUCT(ISNUMBER(MATCH($H$2:$H$31,{"India","USA","Canada"},0))
*ISNUMBER(MATCH($I$2:$I$31,"20",0)))
*ISNUMBER(MATCH($J$2:$J$31,{"Pending",""<>""&"*"},0)) Here in this line I am trying to include Pending or blank cells.
Thanks
mg