View Single Post
 
Old 04-29-2015, 05:33 AM
jester296 jester296 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2015
Posts: 2
jester296 is on a distinguished road
Default 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
Reply With Quote