Countif multiple items

[Romileyrunner1]

HI,
How do I countif a range where I want it to include more than 1 item. I`m
usng the formula :
=COUNTIF(AN10:AN89,{"W","SA+","ST","SA"})

This isn`t working, it`s just counting up the first item, i.e. all the "W"
entries. How do I get it to count all the SA+, ST and the SA as well?

Many thanks.
RR1

 

[Jacob Skaria]

Try..

=SUM(COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}))

If this post helps click Yes

 

[Romileyrunner1]

Cheers Jacob. Works great. That was a quick and perfect answer.
Many thanks.
RR1