Thread
:
SUMPRODUCT vs CSE
View Single Post
#
4
Don Guillett
Posts: n/a
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
Reply With Quote