Agreed, if you compare each element of a 6 element array by each element of
a 9 element array, you get 54 if they all are equal. But I would have
thought that it is trying to compare each element of an array against it's
corresponding element in another array. For this, the arrays need to be the
same size. And then they should be in the same plane to be compared, one is
currently a row, one is a column, so you should transpose the row elements.

This then becomes

=SUM(IF(TRANSPOSE(A5:I5)=B5:B13,1,0))

which will give 9 with your data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matthew S" wrote in message
...
I'm working through an Excel text book (Benchmark Series). There is a
question (Concept Checks- Chapter E3 #16) that asks, "What is wrong with
the
following array formula:"

{=SUM(IF(A5:I5=B5:B10,1,0))}

I set all the cells to a value of 5 and the formula returns a 54, which I
think is correct. Does anyone see anything wrong with the formula?