I have a table in which each column represents a range of dollars. An
x in the row means that the person is in that range. I want to see if
there is a compact means of getting a column with the sum of the low
number in each preceding column and a sum of the high end of the range
for those columns.

For instance, there may be an x in a row where the column is
1000-15000, an x in the next column where the range is 15001-50000 and
a blank for the column 50001-100000. Thus the sum column for low would
show 16001 and the sum column for high would show 65000.

I know that I can create columns like =IF(A2="x",1001,0) and then sum
these columns in another column. Then do a similar formula for the
maximum. Is there a simpler way where a single formula would
accomplish the goal? There are 9 columns. Thanks.

Ken