I do too, should have added that rider in my response.
Bob
"Don Guillett" wrote in message
...
Given the choice I always use sumproduct.
--
Don Guillett
SalesAid Software
"Ron Coderre" wrote in message
...
I work with some Excel users who never remember [Ctrl]+[Shift]+[Enter],
but
will recognize the SUMPRODUCT function on the dropdown list and use it.
Others readily adopt CSE. Consequently, I go back and forth between
using
SUMPRODUCT and CSE, depending on the situation. If I don't own the
workbook,
I tend towards SUMPRODUCT because users can find it in Excel Help if
they
break a formula. Not the case with CSE; once it's broken they have no
idea
how to get it back.
My question: Which method consumes less processor resources?
--
Regards,
Ron