jaypee -

Have you considered putting some field names at the top so that it's an
Excel database/list and then using a Pivot Table to do the counting?

(I don't understand your test data. The SL/VL seems to be irrelevant.)

- Mike
www.mikemiddleton.com

"jaypee" wrote in message
...
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