J_Drake
asked on
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
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
ASKER
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,
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! That was exactly what I was looking for.
=COUNTIF($B$3:$E$32;"High"
but what result you like to see in overall? Maximum? If at least one is High - High, etc?