Help with IF and COUNTIF functions
New to the forum so i apologize if this is in the wrong section but I'm having a little trouble with formulas. Basically column A are months but one month may be used more than once. Columns C-H are questions answered with a Y or N. I need a formula that will add the Y's in a row for each listed under various months. Below is a basic example of what my sheet looks like. Any assistance is greatly appreciated.
JAN Y N Y N N N
JAN N Y Y N Y Y
FEB N N N N N N
JAN Y N N Y Y N
MAR N N Y N Y Y
|