SUMPRODUCT to exclude certain words

[Mehow]

Hi All,

I'm trying to count all cells that contain any text + EXCLUDE certain words

I'm trying to exclude "BRK" and "SCK" and "HOL" from the range.

=SUMPRODUCT(--(T4:AS4<>""),--(T4:AS4<>"BRK"))/2
How do i also exclude "SCK" adding it to above formula?

http://prntscr.com/iiym5u < that's what it looks like now

Thanks,
Michal.

 

[dreid1011]

Welcome to the board.

Add in the extra conditions just like you did with BRK.

Like so:

=SUMPRODUCT(--(T4:AS4<>""),--(T4:AS4<>"BRK"),--(T4:AS4<>"SCK"),--(T4:AS4<>"HOL"))/2

 

[pgc01]

Hi
Welcome to the board

Try:

=SUMPRODUCT(--(T4:AS4<>""),--ISERROR(MATCH(T4:AS4,{"BRK","SCK","HOL"},0)))/2

 

[Mehow]

Works!

Thanks for the quick help and a warm welcome i'm catching up on the excel skills and hopefully will use this forum again and again!

Kind Regards,
Michal.