# {SUM(IF(...} To SUMIF(...)

Apr 4, 2009I have a workbook which I am trying to clean up and make more efficient (in terms of formula calculating time).

In it are examples of array formula such as this one (which work correctly):

{=SUM(IF(Expected!$A7:$A894=5,Expected!$K7:$O894))/3}

From past readings here, I have heard that the array {SUM(IF(...} is slower in calculating than the SUMIF(...) equivalent.

As such i tried to convert is to:

=SUMIF(Expected!$A7:$A894,5,Expected!$K7:$O894)/3

This gives a different answer though. I thought for a single criteria they would be equivalent.

Q1: What am I doing incorrectly above?

Q2: Is there a more efficient version of the array formula I could use (SUMIF and otherwise), so I can have some options availible.