Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif-sumproduct
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
HELP!!!! sumif or sumproduct ??? :( | Excel Worksheet Functions | |||
HELP!!!! sumif or sumproduct ??? :( | Excel Worksheet Functions | |||
SUMIF/SUMPRODUCT?? | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions |