COUNTIF
A function that counts cells matching one condition, such as "OR" or ">40". It ignores capital letters but not stray spaces.
A function that counts cells matching one condition, such as "OR" or ">40". It ignores capital letters but not stray spaces.