COUNTIF formula for multiple criteria

Hi guys,

Can anyone help me with my spreadsheet attached?

I need a countif formula in cell B25 counting data from b2:b20 which counts:

CL, FA Cup, CC, and SC only.
I have tried inputting a few things from a google search with no success!

Can anyone advise?

Thank you.

One option:

Formula:

Please Login or Register  to view this content.

BSB

Thanks BSB - strangely this is not returning the correct results at all! any ideas why?

Originally Posted by tim201110

=SUMPRODUCT(--ISNUMBER(SEARCH($D$1:$G$1,B2:B20)))
in $D$1:$G$1 there are your strings

Thanks tim 201110 - Unfortunately this did not work. I don't think I am quite following you by what you mean in reference to the strings.. sorry

Thanks all! Rep added