Hi Darren

=SUMPRODUCT(--($A$2:$A$1000=666666),--($B$2:$B$100030))
Better to put the values required in separate cells, then there is no need
to change the formula when you look for other results

=SUMPRODUCT(--($A$2:$A$1000=D1),--($B$2:$B$1000E1))

--
Regards
Roger Govier

"Darrren" wrote in message
...
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