sum if question

[SLC]

I want to add any value in a range that can match one of three possible codes.

at the moment i have
(COUNTIF(Range,"2FTC"))+(COUNTIF(Range,"2FTF")+(COUNTIF(Range,"2FTP")))

I am looking for a more efficient formula.

thanks!

 

[njimack]

Confirmed with ctrl+shift+enter:
=COUNT(IF(ISNUMBER(MATCH(Range,{"2FTC","2FTF","2FTP"},0)),1,0))

 

[Misca]

Is =COUNTIF(Range,"2FT?") good enough?

 

[SLC]

Is =COUNTIF(Range,"2FT?") good enough?

Hi Misca, that works perfectly.. thanks.

 

[SLC]

Confirmed with ctrl+shift+enter:
=COUNT(IF(ISNUMBER(MATCH(Range,{"2FTC","2FTF","2FTP"},0)),1,0))

Hi Njimack, thanks for your quick reply. That formula is a bit beyond my level of understanding unfortunatley, but thanks for replying.