excel formula

jaypee · Mar 24, 2006

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

Peo Sjoblom · Mar 24, 2006

=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

excel formula

jaypee

Peo Sjoblom