A1 = Name to check
B1 = "some value" to limit the summed numbers

Sheet2-ColumnC = Names
Sheet2=ColumnF = Numbers to sum

=SUMPRODUCT((Sheet2!$C$1:$C$10=A1)
*(Sheet2!$F$1:$F$10B1)
*(Sheet2!$F$1:$F$10))

Adjust the ranges as needed.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Jerry" wrote:

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