summing a sales history spreadsheet

[bhawkins9991]

I have a spreadsheet with maybe 30,000 rows. It looks something like this

1/15/2010 $25,000 customer A TX USA
1/16/2010 $12000 customer b MA USA
1/17/2010 $19000 customer c Paris France
1/18/2010 $13000 customer d London England
...
...
etc

I need a list of total sales by country. Of course I can sort by country & then add up each country seperately, but there must be an easier way.

Any suggestions?

Thanks,

Bob
Dallas

[shg]

Welcome to the forum.

Pivot tables: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 is among a ton of resources available online.