A single line of code i cant work out...

**PhishTaco** · 03-17-2012, 09:51 PM

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.

**davesexcel** · 03-17-2012, 10:11 PM

Attach a sample workbook showing you original layout and the desired results.
I am assuming you just need a countif formula.

**PhishTaco** · 03-17-2012, 10:13 PM

I worked it out, if anyone is interested on how i did it i used =COUNTIF(V5:AG5, "Y") to count the number of Ys then =IF(AI5>10,"Excellent",IF(AI5>6,"Very Good",IF(AI5>3,"Average","poor"))) to display the rating.

**royUK** · 03-18-2012, 03:49 AM

Why have you posted this programming forum asking for code?

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save