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

"Jacob Skaria" wrote:

Try..

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

If this post helps click Yes
---------------
Jacob Skaria


"Romileyrunner1" wrote:

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