ExcelBanter - Countif multiple items

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countif multiple items (https://www.excelbanter.com/excel-worksheet-functions/240862-countif-multiple-items.html)

Romileyrunner1

Countif multiple items

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

Countif multiple items

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

Romileyrunner1

Countif multiple items

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

All times are GMT +1. The time now is 09:00 AM.