Hello friends ,
Find several times, appears in this series of numbers 1,1,1,2 .
Has a wellknown formula, is not flexible enough and convenient in my opinion,
=SUM((MMULT(COUNTIF(H1:K1,A1:D20),{1;1;1;1})=10)),
Of course, the challenge is to find another formula.
My formula works only on positive numbers (including 0)
Conditioning is, without volatile functions.
Good luck!
David
Find several times, appears in this series of numbers 1,1,1,2 .
Has a wellknown formula, is not flexible enough and convenient in my opinion,
=SUM((MMULT(COUNTIF(H1:K1,A1:D20),{1;1;1;1})=10)),
Of course, the challenge is to find another formula.
My formula works only on positive numbers (including 0)
Conditioning is, without volatile functions.
Good luck!
David
Attachments

8.7 KB Views: 35