Capture.jpg
For anyone who cannot see the image, here is the text:
Here is the conundrum (in simplified terms):
I need to make a formula that will say if students play a sport. I have the data inputted with every student constituting a row, and different statistics for each column.
The other statistics (GPA, Shooting %, RBI) are irrelevant to this question and hence marked with an "x"
The sheet uses binomial coding where 0 signifies a "No" and 1 signifies a "Yes," (and no, I cannot change this formatting)
If I need to know how many students play any sport, how can I create a formula that will give me a binomial (0 or 1) answer for the final column, "does the student play sports?"
[I have filled it in with the expected (human-generated) answer to test the formula]
Ex table
GPA Play Basketball? Shooting Percentage Play Baseball? RBI Play sports?
Student1 x 0 x 1 x 1
Student2 x 1 x 0 x 1
Student3 x 1 x 1 x 1
Student4 x 1 x 1 x 1
Student5 x 0 x 0 x 0
Student6 x 0 x 1 x 1
Student7 x 0 x 1 x 1
Student8 x 0 x 0 x 0
Student9 x 1 x 0 x 1
Student10 x 1 x 0 x 1
Student11 x 1 x 1 x 1
I have tried making the final column
= IF(SUM(C10, E10)>0, 1, 0)
but Excel cannot process that command
= IF(SUMPRODUCT(C10, E10)<1, 0, 1)
but any student who plays one sport, but not the other, will not be counted
Do you have any suggestions?
Bookmarks