Thanks for your answer, Bob.
Roberto

"Bob Phillips" ha scritto nel messaggio
...
: Because it is optimised for conditional counting, so when you only have one
: condition, use SUMIF. SUMPRODUCT is good for multiple conditions, but the --
: is coercing a TRUE/FALSE result to 1/0 so that it can do the product can be
: executed. It also looks more intuitive, no --.
:
: I just did a quick test, and in this SUMIF was quicker than SUMPRODUCT by a
: factor of some 42%.
:
: That is why it is better in the right circumstances.
:
: --
: HTH
:
: Bob Phillips
:
: (remove nothere from email address if mailing direct)
:
: "Roberto" <schebobchiocciolatinpuntoit wrote in message
: ...
:
: "Bob Phillips" ha scritto nel
: messaggio
: ...
: : No, no. Ron gave you the proper answer.
: :
: Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
: Roberto
:
:
:
: