Forum Discussion
IF/AND Function?
The attached spreadsheet represents a test with Yes and No answers to 24 questions. I'm trying to come up with a formula that tells me how many Yes or No's to each question. For example, question 1...
STRACTROOP There are many ways to do this and I don't know that any one is much better then another. Here is 1 option using SUMIFS
=SUMIFS(C$2:C$9,$B$2:$B$9,$A$14#)where C2:C9 is the range of YES or NO and B2:B9 is the question #s and A14# is a spill range with the list of question #s (in the attached I used UNIQUE() but you could just as easily use SEQUENCE() or old school use ROW(A1:A8)