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:J 30)

--
Biff
Microsoft Excel MVP


"Gordy" wrote in message
...
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.