I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far.
=IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red", IF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Yellow") > 0, "Yellow", IF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Green") > 3, "Green", IF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Blue") = 4, "Blue"