=COUNTIF(VLOOKUP(B2, SET,4,TRUE),1)

I am trying to use the above formula but it keeps coming back telling me
there is an error with it. Bascially I want to count how many rows in "SET"
are equal to 1 when a Column in "SET" is equal to the number in B2.

VLOOKUP will only return a singles result.

What exactly are you trying to do, and how is the data setup?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sheena" wrote in message
...
=COUNTIF(VLOOKUP(B2, SET,4,TRUE),1)

I am trying to use the above formula but it keeps coming back telling me
there is an error with it. Bascially I want to count how many rows in
"SET"
are equal to 1 when a Column in "SET" is equal to the number in B2.