If a row contains data in multiple columns, assign a score of 1

[Walesb]

Hello all

I am using Excel 2003 and I have a problem that I believe will be solved with an IF function, I'm just not entirely sure how to apply it!

I have enclosed an example table

Basically, I need to count any row that has a x in any column between B and H. For example row 2 contains 3 x's (in cells B2, E2 and G2) needs to be classified as 1 row which contains an x. I can't use a nested IF function as in reality the table I'm using spans 26 columns...


Hopefully I have explained this properly! Any help is massively appreciated

	A	B	C	D	E	F	G	H
1
2	ABC	x			x		x
3	ABC		x
4	XYZ	x		x		x		x
5	XYZ							x
6	ABC

<TBODY>
</TBODY>

 

[Andrew Poulsom]

Example:

=(COUNTIF(B2:H2,"x")>0)+0