Thread: COUNTIF Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheena Sheena is offline
external usenet poster
 
Posts: 6
Default 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.