View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sjl sjl is offline
external usenet poster
 
Posts: 8
Default countif w/vlookup

countif(range,criteria)
sawmill table is
10 125
12 150
14 175
i have a large range of numbers and am trying to use a vlookup in the
criteria.
i cant get this formula to work =countif(c15:c500,"<"vlookup(c8,sawmill,2))
where c8 is a value of 10, 12 or 14

thanks for any help