Help - How to: IF x is in one or more columns count how many have one or more x's?

ando1234 

=SUMPRODUCT(N((COUNTIF(OFFSET(B2:F2,ROW(1:5)-1,),"x")>0)))

An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

ando1234 

https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34

in G2 and copy down:

=COUNTIF(B2:F2, "x")