sumif and left

B

Bonita

col a col b
103 100
204 500

need to sum col b based on the first left character of col a
ie 1 100
2 500
 
M

Mike H

Hi,

This works for your posted data

=SUMPRODUCT((INT(A1:A10/100))*(B1:B10))

Mike
 
Top