View Single Post
  #1   Report Post  
Ron Coderre
 
Posts: n/a
Default SUMPRODUCT vs CSE

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