#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Welcome...so for the above, do you want 2,4,0,3,3 or are all JANs to be combined?
For the former, enter the following formula in the first row after the last column of answers. So if the data start in row 1 and there are seven columns as above: =countif(B1:G1,"Y") Copy it down the list. Then if you want to combine all JANs, you would make another list elsewhere with each month, say in column J. Then in K you would have: =SUMIF(A:A,J1,H:H) See attached file if this makes sense. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CountIF Functions | Alaska1 | Excel | 4 | 01-30-2015 09:59 AM |
COUNTIF Formula | teza2k06 | Excel | 3 | 02-13-2014 12:37 PM |
Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
Countif issue | Katy I | Excel | 2 | 07-11-2012 06:30 AM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |