Hi

I would expect the SUMIF to be faster.

The use of the double unary minus -- is to coerce the result of the test
SCHOOL!$J$1:$J$950=$B$1
from True False to 1 and 0, so they can be multiplied by the values in
V1:V950.
The results of that, either the value from column V where J = B1, or 0 where
the value in J does not equal B1, are then summed to produce your result.

For more help on this topic read the excellent documents by
Bob Phillips at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

or by JE McGimpsey at
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

--
Regards
Roger Govier



"yshridhar" wrote in message
...
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