I have rows of data divided into counties with tonnage amounts in a
cooresponding cell. I need to have one row for each county, and the tonnage
for each separate one summed. Here is an example of what I mean....

State County Tons Commodity
LA ACADIA 1.5 AMMONIUM NITRATE
LA ACADIA 21.82 AMMONIUM NITRATE
LA ACADIA 0.3 AMMONIUM NITRATE
LA ACADIA 414.85 AMMONIUM NITRATE
LA ACADIA 9.1 AMMONIUM NITRATE
LA ACADIA 2.23 AMMONIUM NITRATE
LA ACADIA 38.73 AMMONIUM NITRATE
LA ACADIA 5809.16 AMMONIUM NITRATE
LA ACADIA 50.65 AMMONIUM NITRATE

So it should read:
LA ACADIA 6348.34 AMMONIUM NITRATE

I have hundreds of counties over 10 different spreadsheets.
Can you help??

--
taz0923