calculate the number of occurrences of a "Letter" based on a percentage

[scottmcclean]

Hi there,
I hope you can point me in the right direction. I am trying to create a RAG status report and have a 4 cells that contain a letter based on a score. I would like to total that range of cells using a weighted percentage so that it returns a letter value based on that percentage weighting. E.g if there are three letter "G's" (75%) in the range then I would like the total to display a "G". If there was one "G", two "A's" and an "R" (25%) I would like it to display "R" in the total.

Team Rating
Team1 R
Team1 G
Team1 A
Team1 R

Overall XXX

IF "G" is >75% then insert "G"
IF "A" is >50% then insert "A"
IF "R" is >=25% then insert "R"

I am struggling to figure out how I could do this as a formula, so would appreciate any pointers. I would like to have the % within the fomula so that I can change if necessary

Many thanks

 

[NeonRedSharpie]

=COUNTIF()/COUNTA() will get you your percentage of a certain letter. Then, just use your IF logic to get the right value.

 

[TechKnowledge]

Is this what you're looking for?

https://dl.dropboxusercontent.com/u/65572133/occurences of a letter.xlsx