SUM

More Useful Array Constant Formulas

I have been recently blogging on Array Constants (see below links) and how useful they are for simpler, more maintainable and readable formulas. ttps://www.theexcelfactor.com/using-array-constants-formulas-logic/ https://www.theexcelfactor.com/using-array-constant-list-formulas/ Also I often use SUMIFS which from the top of my head came with Excel 2007.  I did a job a few years ago that had another useful application of …

More Useful Array Constant Formulas Read More »