The reverse COUNTIFS is to avoid excel not wanting calculated range in the criteria range :) Level 5 is next to come!

@@LorenzoFoti You’re right to be cautious… but in this case I’m 99% sure the reverse version would work! OFFSET and INDIRECT both return ranges, so they’re usable in a COUNTIF.

@@DimEarly You are right, it works. But now I am a bit confused on what is not liked by the criteria range, a returned range is ok, a calculated one is not? Aren't them the same?

@@LorenzoFoti It gets a little subtle… a function that does a calculation but returns a reference to a range is OK, but a function that returns an array that’s not a range reference is not OK. Unfortunately, it’s not always obvious which is which - e.g. I think CHOOSECOLS returns an array not a range reference, even if you give it a range as input and choose consecutive columns (so that the output ‘could’ be a range). But OFFSET, INDEX, XLOOKUP, and some others, return range references when they can.