Thank you Roger and Mike. Very much appreciate your assistance

Darren

"Mike H" wrote:

Try

=SUMPRODUCT((A1:A20=666666)*(B1:B2030))

Mike

"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