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.
|