We need a fuller explanation of how the data is stored and what you want to
see
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"caldog" wrote in message
...
I have looked at the rank function, but I do not think that it is the
function for what I need.

I have a list of salesmen, four in total, that sell three different types
of
merchandise.

How would I rank number one through four, based on how they sold each of
the
six different types of merchandise.

Example:

Salesman 1,6,18,4
Salesman 2,11,0,3
Salesman 3,2,5,20
Salesman 4,1,3,2

To complicate matters each set of merchandise categories is sorted
individually by amount sold.

Merchandise #1
Salesman 2 11
Salesman 1 6
Salesman 3 2
Salesman 4 1

Merchandise #2
Salesman 1 18
Salesman 3 5
Salesman 4 3
Salesman 2 0

Merchandise #3
Salesman 3 20
Salesman 1 4
Salesman 2 3
Salesman 4 2

Total Sales and Ranking
Salesman 1 28
Salesmen 3 27
Salesmen 2 14
Salesmen 4 6

So what I am looking for is a formula that will put the combined total by
the right salesman, and when I sort by using Data-Sort, each salesman
keeps
its correct total.

Steve