Countif?

G

Gordy

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

T. Valko

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)
 
Top