excel formula

good day!

i need a excel formula that counts FAC, 1,SL or VL as 1.

FAC 1 SL
FAC 1 SL
FAC 2 SL
FAC 1 VL
FIS 1 VL

in this sample the formula must count 3..

thanks

=SUMPRODUCT(((C1:C5="SL")+(C1:C5="VL")),--(B1:B5=1),--(A1:A5="FAC"))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"jaypee" <jaypee2cool@yahoo.com> wrote in message
news:%23cb8UJvTGHA.6084@TK2MSFTNGP14.phx.gbl...
> good day!
>
> i need a excel formula that counts FAC, 1,SL or VL as 1.
>
> FAC 1 SL
> FAC 1 SL
> FAC 2 SL
> FAC 1 VL
> FIS 1 VL
>
> in this sample the formula must count 3..
>
> thanks
>
>