Multiple values in one cell for sumif function

Or, as daddylongs already said, if you can write only first numbers in your cells.. Your formula might become much simplier:

(note that if you write 1000-1800, 1810-2200, 2210 - ...) is same as up to 1000, 1800, 2200...