Combining COUNTIF and OR [SOLVED]

hi everyone,

In a range, by example C2:C20, I have everytime one letter of the alphabet (for the moment only A, B, C, D or E)

I would like to count the number of As and Bs

For the moment I have solved my problem by adding both counts:
=COUNTIF(C2:C20,"A")+COUNTIF(C2:C20,"B")

But since I intend to extend the range and the number of letters to count, I'd like to know if there is a way to write, by example

=COUNTIF(C2:C20,"A" OR "B")

TonyB appears to have misplaced the intended attachment - without knowing if I am replicating his/her suggestion, given the values are "constants" you could use:

=SUM(COUNTIF(C2:C20,{"A","B","D"}))

which is equivalent to

=COUNTIF(C2:C20,"A")+COUNTIF(C2:C20,"B")+COUNTIF(C2:C20,"D")

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save