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 As a variant, how about a good old pivot table. That is, if you are not forced somehow to use spreadsheet functions.
Some examples in the attached file, with and without changing the set-up of your data. It doesn't really matter.