I assume you are trying to do a countif with 3 criteria and you have 3
columns of data you are checking. So you want to know if FAC is in
column 1, 1 is in column 2, and either SL or VL is in column 3. The
way to do a 3-criteria count is to use an array formula. Assuming we
are using columns A, B, and C this would be your formula:


=SUM(IF((A1:A5="FAC")*(B1:B5=1)*(C1:C5={"SL","VL"} ),1,0))

This is an array formula, so you will have to press ctrl+shift+enter
instead of just enter when you finish the formula. If you do it right
you should get brackets around the formula.

You can change the ranges to meet your needs.