finding data between two numbers (1000-1999)and totaling correspo.

P

plasticmaker

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.
 
J

JE McGimpsey

one way:

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


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