Forum Discussion
Help - How to: IF x is in one or more columns count how many have one or more x's?
How would you count how many have one or more x's (per row)?
=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.