sumifs or other formulas

[mls28]

Hi - what formula can I use to find annual total sales for the top 3 salespeople from a range of data? I can't use pivot tables. I know maxif is used for the highest. Thx

 

[awoohaw]

Your question leaves a lot of room for interpretation.
For instance, this does not take ties into consideration.
To enter the formula you must use the CSE key stroke (CNTL-SHFT-ENTER). And I'm unsure if AGGREGATE and the bracket array works.

Book1
	A	B
1	Salesperson
2	SP1	10
3	SP2	14
4	SP3	14
5	SP4	10
6	SP5	12
7	SP6	15
8
9
10	43
Sheet1

Cell Formulas
Range	Formula
A10	A10	=SUM(AGGREGATE(14,6,$B$2:$B$7,{1,2,3}))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

I know maxif is used for the highest

What version of Excel are you actually using as maxifs does not exist in xl2010?

 

[mls28]

What version of Excel are you actually using as maxifs does not exist in xl2010?

not sure

 

[Fluff]

If you click on File, Account, it will tell you what you are using.