which is better?

[Dr. Harvey Waxman]

{=SUM(IF(E15:E11000="",B15:B11000))}

or

=SUMIF(E15:E11000,"",B15:B11000))

I believe these are functionally equivalent but is one more or less efficient?

Thanks

 

[JE McGimpsey]

SUMIF is more efficient, since it has optimized routines for evaluating
the arrays. Array-entering the SUM() formula requires some additional
overhead.

In general, if you can replace two functions with one, you should. For
instance, SUMPRODUCT() is far more efficient than an array entered SUM()
function.

 

[Harvey Waxman]

SUMIF is more efficient, since it has optimized routines for evaluating
the arrays. Array-entering the SUM() formula requires some additional
overhead.

In general, if you can replace two functions with one, you should. For
instance, SUMPRODUCT() is far more efficient than an array entered SUM()
function.

Thanks again