Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks, Bob. I didn't notice an obvious difference, hence the question.
-- Regards, Ron |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |