Two COUNTIF formula in one cell

[hollies]

I have a table that counts the number of "Y" that i add to cells =COUNTIF(H2:O2,"Y")

Conditional formatting then turns the cell fill to green.

Is it possible to add another COUNTIF in the same cell if I put a "B" instead of a "Y"?

I need the total number on Column O to read the same whether it is counting "B" or "Y"

As you can see in the attached image, the count is only good for "Y".

COUNTIF.JPG

Many thanks

Rob

[JohnTopley]

This ???

=COUNTIF(H2:O2,"Y")+COUNTIF(H2:O2,"B")

or

=SUM(COUNTIF(H2:O2,{"Y","B"}))

[hollies]

Many thanks for your swift reply John


Both actually worked and produced the result I want.

I tried a few attempts myself but couldn't get it right!

Thanks again, much appreciated.

Rob