ando1234Copper ContributorMay 16, 2023Help - 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)? Show More
LorenzoSilver ContributorMay 16, 2023ando1234 https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34 in G2 and copy down:=COUNTIF(B2:F2, "x")