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