Countif?
 

working with 8 columns and 30+ rows by place an "x" in various places, I need
a formula that will tell me how many rows have 2 or more "x" in it.

Countif?
 

Try this array formula**:

=SUMPRODUCT(--(MMULT(--(A1:H30="X"),TRANSPOSE(COLUMN(A1:H30)^0))=2))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Gordy" wrote in message
...
working with 8 columns and 30+ rows by place an "x" in various places, I
need
a formula that will tell me how many rows have 2 or more "x" in it.