Hi,

This works for your posted data

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

Mike

"Bonita" wrote:

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

--
Bonita