Hi All,

I'm trying to count 3 columns that meet certain criteria. I compare a single value with multiple values in an array. The first two columsn are easy, as they meet a single value. The third column should compare the value in the array with another array

Example
=SUM(IF((D:D="02. Medium")*(E:E="1-Blocking")*(B:B = $F$1:$F$4);1;0)

The bold part i can't seem to work. Should i nest another formula?

Please let me know if i'm unclear.

so the three criteria should be true, but the value that is being cel that is being check in column B should exist in $F$1:$F$4.