=SUMPRODUCT((A1:A100=666666)*(B1:B10050))

so data like:

666666 1
666666 1
666666 100
666666 100
555555 100
555555 1
555555 1
555555 1

yields a 2
--
Gary''s Student - gsnu200819


"Darrren" wrote:

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30