ranking - only multiple criterias

[bluepenink]

Hello

Having some trouble/not sure how to make this calculation.

basically, i have ranked based on a few criterias a few sales ppl., but now i would like to do an overall rank, based on their ranking.

i.e. if there are four criterias
Sales Person - Criteria 1 - Criteria 2 - Criteria 3 - Criteria 4
John Doe rank= 1 rank= 1 rank= 1 rank= 1

thus his overall rank is #1.

how can i make taht calculation? for his overall..using all his rankings? hope u guys follow.

unfortunately firewall do not allow me to upload files, so i have uploaded a file on the website below, if someone can pls advise!!
http://www.excelforum.com/excel-general/783906-overall-ranking.html

thx you!

 

[T. Valko]

Hello

Having some trouble/not sure how to make this calculation.

basically, i have ranked based on a few criterias a few sales ppl., but now i would like to do an overall rank, based on their ranking.

i.e. if there are four criterias
Sales Person - Criteria 1 - Criteria 2 - Criteria 3 - Criteria 4
John Doe rank= 1 rank= 1 rank= 1 rank= 1

thus his overall rank is #1.

how can i make taht calculation? for his overall..using all his rankings? hope u guys follow.

unfortunately firewall do not allow me to upload files, so i have uploaded a file on the website below, if someone can pls advise!!
http://www.excelforum.com/excel-general/783906-overall-ranking.html

thx you!

It sounds like what you want to do is get a sum total of the sub-ranks and then get a grand rank from this.

Does that sound right?

Can't download files from that site unless you're a registered member.

 

[bluepenink]

hello

thxs for ur prompt response.

yes, you are correct. any ideas how? thxs alot.

 

[T. Valko]

hello

thxs for ur prompt response.

yes, you are correct. any ideas how? thxs alot.

Maybe something like this...

Book1
	A	B	C	D	E	F
1	_	Rank1	Rank2	Rank3	Total	Final Rank
2	Bob	2	1	4	7	4
3	Sue	4	5	2	11	2
4	Biff	5	4	5	14	1
5	Tom	3	2	3	8	3
6	Lisa	1	3	1	5	5
Sheet1

Higher numbers are better.

This formula entered in E2 and copy down to E6:

=SUM(B2:D2)

This formula entered in F2 and copied down to F6:

=RANK(E2,E$2:E$6)