CSE formula Over Sumproduct()

  • Thread starter Thread starter JimMay
  • Start date Start date
J

JimMay

Is there clear criteria for going with a
Control-array formula over the Sumproduct() formula?

Or is it as simple as:
If the Sumproduct() formula "doesn't work"
Do a re-write assemblying a CSE formula.

All comments MOST welcome.
 
Jim,
I am not (as a relative novice!) aware of major
advantages/disadvntages to either. Where there is a choice, my own preference
is SUMPRODUCT simply because I find it "easier" to understand and/or because
of my own lack of knowledge on array formulae [which is improving thanks to
the many expert contributors to the Excel NGs].


Maybe horses for courses?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct Function 3
UNABLE to conditional format CSE formulas cells 1
Sumproduct formula 3
Require formula to search across multiple worksheets 2
Multisheet range in SUMPRODUCT? 5
sumproduct of multiple sheets 5
What is "--" in Excel Formula (SUMPRODUCT) 2
Sumproduct formula needed 2

Back
Top