Count formula with execpt

[cactusjomak]

I have found an issue in my count formula: =COUNTA(B11:B23)

This just counts the value, but I need it to exclude the words "VAC" "OUT" "H" is there a way to do this?

(the values that I count are like "7a-5p")

 

[Aladin Akyurek]

I have found an issue in my count formula: =COUNTA(B11:B23)

This just counts the value, but I need it to exclude the words "VAC" "OUT" "H" is there a way to do this?

(the values that I count are like "7a-5p")

One of:

=COUNTA(B11:B23)-SUM(COUNTIF(B11:B23,{"VAC","OUT","H"}))

=SUMPRODUCT(--ISNA(MATCH(B11:B23,{"VAC","OUT","H"},0)))

 

[cactusjomak]

[quote="Aladin Akyurek
One of:

=COUNTA(B11:B23)-SUM(COUNTIF(B11:B23,{"VAC","OUT","H"}))

=SUMPRODUCT(--ISNA(MATCH(B11:B23,{"VAC","OUT","H"},0)))[/quote]

Yes, I need to be educated in formulas THANKS!