(this thread is re-posted from an earlier attempt with a non-descriptive title, at JB's request)

In Excel 2003 I'm trying to work with two columns of data. In one column are account numbers, the other is dollar values for the account.

I want a formula that will sum all data in the amount column for a given range of account numbers. Say from 600000-600199, from 600200-600299, etc. Of course I have more data than below. I have been trying to use >, <, in SUMIF arrays (no SUMIFS in '03).

Account Amount
600108 1,459
600109 16
600113 18,449
600201 0
600202 0
600203 0
600205 15,468
600206 581
600208 0
600209 0
600210 152
600212 987
600508 183
600702 0
601101 9,881
601104 11,357
601107 1,454

Any suggestions would be appreciated. Once this is worked out, I'll be using the solution for years.

PS, First post, new user. Hope I'm not asking something I could have easily found using search...

Ernest T