excel problem

Hi All,

I have a spreadsheet which has 4 categories; I need these 4 categories for each entry to rank high =3, med=2,low=1, or N/A=0. Based off the scores of the 4 categories I need a final column "Overall" to populate with a low,med,or high.  Please let me know if further clarification is needed.

*Please see attachment.

Thanks,example.xlsx
J_DrakeAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try this formula in G3

=VLOOKUP(MATCH(B3,{"N/A","Low","Medium","High"},0)-1+MATCH(C3,{"N/A","Low","Medium","High"},0)-1+MATCH(D3,{"N/A","Low","Medium","High"},0)-1+MATCH(E3,{"N/A","Low","Medium","High"},0),{0,"N/A";1,"Low";5,"Medium";8,"High"},2)
0
 
als315Commented:
It is not a problem to calculate totals (for High, for example):
=COUNTIF($B$3:$E$32;"High")
but what result you like to see in overall? Maximum? If at least one is High - High, etc?
0
 
J_DrakeAuthor Commented:
Hi,

Thanks for the response. The overall column I need to be an average of the other 4 categories based on these values: high =3, med=2,low=1, or N/A=0.

Then I need run that against the listing p15:18.

Example- entry 1 is made up of a null (0),low(1),low(1),null(0) this would be 2 points.
I need this to be less than or equal to 4 but greater than zero- which would make it a low.

Let me know if you need further clarification of what I'm trying to do.


Thanks again,
0
 
J_DrakeAuthor Commented:
Thanks! That was exactly what I was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.