You might find dynamic named ranges to help keep things orderly. That way you can refer to the ranges by name, and also not have to worry about your $E$1:$E10000 not being up to date when there's 15000 rows of data instead of 10000.

You could do something like this:

{SUM(IF(country_name = "England",bill_amt,0))}

http://www.ozgrid.com/Excel/DynamicRanges.htm