countif2

G

Gordy

Have 10 columns and 30+ rows. Various placements of "x" in this range. Need
formula that will result in denoting that if based upon a row whether 1 "x"
or numerous "x" are placed on that row. In otherwards If 1 "x" or numerous
"x" in a row give me a value of 1 for that row but will sum up the different
rows if statement is met.
 
T

T. Valko

Huh?

I guess this is related to your other post.

Based on your other post...

To sum the values in column J where there are 2 or more X's on the same row.

Try this array formula**:

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