This would be really easy to do with MS Access, but challenging in MS Excel.

In Excel, you could list all counties and products on a seperate worksheet
then use the sumproduct formula to lookup the sums. Not a very elegant
solution but it might work.

Tom

"TriciaZ" wrote:

I used the pivot table and it worked like a charm.
However, the data is going to be transferred into another program
and it needs to be in the same format as the original with headers like:

State County Tons Commodity

I have played around with the pivot table some, but it is not right.
Perhaps a formula or function would work better? Thanks!


--
taz0923