EXCEL 2007

Hi Tricia.

It looks like you need a Pivot Table.

Please look at:-

http://www.pierrefondes.com/

- where I have just put up your example at number 86.

I have added a couple of counties so you can see how things work.

You may need to move some of the information that you have in other
Worksheets into a single Worksheet. I appreciate that this would involve
effort on your part.

Please hit Yes if my comments have helped.

Thanks.

"TriciaZ" wrote:

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