Multiple values in one cell for sumif function

It might be easier to split your ranges out into 2 columns then you could use a regular SUMIFS formula, otherwise.....

Assuming the ranges are in column A, always separated by a hyphen and the amount to sum in column B then with a specific GL in D2 use this formula in E2

=SUM(IF((D2>=IFERROR(LEFT(A$1:A$100,FIND("-",A$1:A$100)-1)+0,0))*(D2<=IFERROR(REPLACE(A$1:A$100,1,FIND("-",A$1:A$100),"")+0,0)),B$1:B$100))

confirmed with CTRL+SHIFT+ENTER

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