Tag: SUM

Using INDEX to help you dynamically calculate a moving average

I have blogged before about how much I love INDEX (INDEX what’s the Big Deal ).  Its powerful, nimble (non volatile so easy on performance load) and just makes so much sense to me given we are working with a

Tagged with: , ,

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

Tagged with: , , ,