SUMPRODUCT vs CSE

[Guest]

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?

 

[Bob Phillips]

Ron,

It's horses for courses, some problems don't get solved by SUMPRODUCT, but
are by SUM(IF as an array formula.

In our tests we found that SUMPRODUCT was generally faster than array
formulae, but it only becomes noticeable on a busy, high density formula
worksheet.

 

[Guest]

Thanks, Bob. I didn't notice an obvious difference, hence the question.

 

[Don Guillett]

Given the choice I always use sumproduct.

 

[Bob Phillips]

I do too, should have added that rider in my response.

Bob

Given the choice I always use sumproduct.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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?