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

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.

--
HTH

Bob Phillips

"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

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

--
Regards,
Ron

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

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