Nov 16 2021 10:20 AM
View best response
Nov 16 2021 10:33 AM
@juntjoo
=SUMPRODUCT((ISNUMBER(SEARCH("1",A4:A7)))*(B4:B7>0)*(C4:C7>0))
I suggest above formula.
Nov 16 2021 10:46 AM
Nov 16 2021 10:51 AM
Nov 16 2021 10:54 AM
View solution in original post