I have a spreadsheet that i would like to shorten the formulas (if possible).
I have discovered that it is possible to shorten SUMIFS using the {curly brackets} to make an array of the options for a given range.
However, I still havent found if there is similar method for COUNTIF.
I did try to use the {curly brackets} method on a COUNTIF formula, but it doesnt seem to work.
Does anyone know of methods to shorten formulas that have repeated sections, and for what functions they can be applied to?











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks