Does anyone have a formula that counts the number of occurances in a range of
cells in another sheet based on the following criteria, 1. it equals the
value in a cell on another sheet, and 2. its less than "some value". For
instance I have a list on Sheet 1 that contains 26 names, on another sheet I
have a table of data where column C contains the same names on Sheet 1 only
multiple times, in Column F I have a list of numbers, but I only want to
count those numbers that correspond to the name on Sheet 1 and are over a
certain value, I have tried Count, Count if, Count with and If and I keep
getting formula errors. please help.
--
Thanks