excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
i have countif with if formula, like this:
=IF(COUNTIF(H2:L2,"=1")>2,1,0)
and
=IF(COUNTIF(H2:L2,"=2")>2,1,0)
and
=IF(COUNTIF(H2:L2,"=3")>2,1,0)
up to "=9"
when h2:l2 refer to differences between 6 numbers in a2:f2
(b2-a2, c2-b2, d2-c2. e2-d2, f2-e2)
can i put all in one formula? including the h2:l2
i have countif with if formula, like this:
=IF(COUNTIF(H2:L2,"=1")>2,1,0)
and
=IF(COUNTIF(H2:L2,"=2")>2,1,0)
and
=IF(COUNTIF(H2:L2,"=3")>2,1,0)
up to "=9"
when h2:l2 refer to differences between 6 numbers in a2:f2
(b2-a2, c2-b2, d2-c2. e2-d2, f2-e2)
can i put all in one formula? including the h2:l2