Counif

[Hedgefund]

Is there another formula that would be easier to use, then the one listed below, which returns the same amount:

=COUNTIF(AF20:AF111,"*Cash**")+COUNTIF(AF20:AF111,"*wats**")


Wats
Cash
Wats
Cash

 

[Jonmo1]

Try

=SUM(COUNTIF(AF20:AF111,{"*Cash**","*wats**"}))

 

[Hedgefund]

That worked, thanks.

Try

=SUM(COUNTIF(AF20:AF111,{"*Cash**","*wats**"}))

 

[Scott Huish]

You shouldn't need 2 asterisks at the end of each string.

=SUM(COUNTIF(AF20:AF111,{"*Cash*","*wats*"}))

 

[Hedgefund]

You are correct, thanks.

You shouldn't need 2 asterisks at the end of each string.

=SUM(COUNTIF(AF20:AF111,{"*Cash*","*wats*"}))