Hi, i have a project to do for my IT class and since i havnt used excel much before i dont know how to do it. So, what im trying to do is have a list of the 12 months and for each month a Y or N for yes or no, on whether the person came to the meeting that month. I need to be able to count how many Ys there are in the 12 month period and display "Poor" (1 - 3 Ys), "Average" (4-6), "Very Good" (7 - 10) and "Excellent (11 - 12). I am guessing i will have t use nested IF statements and as a test i was thinking of using - =IF(W5:AH5 = "Y", "test good", "Test bad") - but it just says #VALUE! in the box.

Thanks for the help.