Perhaps something like this:

3 digit
=SUMPRODUCT((LEFT(B2:B100,3)="111")*E2:E100)

2 digit
=SUMPRODUCT((LEFT(B2:B100,2)="11")*E2:E100)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"oscarcounts" wrote:
I column B I have code numbers, 4 and 5 digit. In column E I have
corresponding financial values. I want to sum values which correspond to
sections of code numbers. ie by reading the first two or three digits of
grouped code number.