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?