View Single Post
  #4   Report Post  
Don Guillett
 
Posts: n/a
Default

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