Tag: SUMIFS

Well it’s the Boxing Day holiday here in Aussieland and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day.  Fantastic stuff.  But also, this is the time of the year to think …

Make Using Tables your New Year’s Resolution Read More »

Tagged with: , , , , , ,

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 …

More Useful Array Constant Formulas Read More »

Tagged with: , , ,