Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |