I need to come up with a spreadsheet, instead of a database, that will allow
someone to enter

Salesman; Company Sold To; State the company is in; & The amount of pairs
the company bought.

I'm thinking Column A to be Salesman; Column B Companies; so forth...

What would be the easiest way, to show the percentage of overall pairs sold
to a certain state?