Hi runelady,

See the attached to see if this is the answer you are looking for.
Countif in Range.xlsx