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

[ando1234]

How would you count how many have one or more x's (per row)?

[#2]

@ando1234 

COUNTIF function

in G2 and copy down:

=COUNTIF(B2:F2, "x")

[#3]

@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.