one way:

With 4 digit numbers in A1:A1000, and corresponding column B:


=SUMPRODUCT(--(INT(A1:A1000/100)=10),B1:B1000)


In article ,
plasticmaker wrote:

I have a list of four digit numbers. I need to search the list and any that
start with 10.. I have to total the numbers from a corresponding column of
all that match this criteria and display it.