sumif-sumproduct
SUMIF is faster, particularly with larger arrays.
The -- converts the True/False values to 1's and 0's to be used in the
SUMPRODUCT formula, and yes, it can be used in other formulae to
convert Boolean values to numeric.
Hope this helps.
Pete
On Sep 12, 9:16 am, yshridhar
wrote:
Hello everybody
Which is more advantegious sumif or sumproduct in terms of execution speed?
the following are my formulae both are giving same result.
=SUMif(SCHOOL!$J$1:$J$950,$B$1,SCHOOL!$V$1:$V$950)
=SUMPRODUCT(--(SCHOOL!$J$1:$J$950=$B$1),(SCHOOL!$V$1:$V$950))
My second question:
What is the significance of "--" in the formula? When i remove it the
formula results in error. Can it be use with other formulae?
Thanks for all
Sridhar
|