COUNTIF Formula
=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.
|