I have a Salesperson worksheet having the following structure:

Column A Column B

Person1 Sales

Person2 Sales

Person3 Sales

Sub Total

Person 4 Sales

Person 5 Sales

Person 6 Sales

Sub Total

and so forth. When using the RANK Function, I want to exclude the subtotal column in the range field else RANK Function will rank that also. How do I go about excluding the subtotal column in RANK functions range field ?

Thanks for replying

ash