Hi,

I am trying to count number of values in a certain column but at the same
time it should exclude some other values in the column from another sheet.
For instance I want to what other internet connection the users used
excluding Cable, DSL, T1 etc.
=SUMPRODUCT(--(CrseEvalData!H6:H50<"Cable,DSL,T1"),--(CrseEvalData!H6:H50<"")) function does not work. It counts all the values in the column.

What function can I use for my purpose?
Thanks.