I have a huge database in wich some fields are strings. I need to count
records based - amongst others - on the two last characters of a field.
However, I must differentiate between az, aZ, AZ etc.

The COUNTIF does not allow for that (Right?).
I can circumvent the COUNTIF through using SUMPRODUCT, e.g.

SUMPRODUCT((ISNUMBER(FIND("aZ",RIGHT(Field1,2)))*( Field2=condition)))

I have the impression that Excel becomes very slow by using this.

So far for the COUNT; but I would liek as well to filter specific records on
the database with e.g. the Advanced Filter, how do I enter a criterion to
filter out records with last 2 characters "aZ" (and not extract "AZ" and so
on)?

Thanks, Alain