Depends what it's supposed to be doing, I'd say The SUM part of the formula
is not required, however I can't see how you are getting the answer 54 when
the IF function says return either 1 or 0

"Matthew S" wrote:

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?