which is better?

  • Thread starter Dr. Harvey Waxman
  • Start date
D

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
 
J

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.
 
H

Harvey Waxman

JE McGimpsey said:
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.
Click to expand...


Thanks again
 
Top