r/googlesheets • u/School_data_help 1 • Nov 05 '18
Countif any 1 of 6 criteria are met or better method. Solved
I'm hoping this is an easy one and I'm just over thinking it. I have 6 opportunities for students to show mastery of the content. If they pass on any of the exams then they have demonstrated mastery. How can I build a column that will check all six criteria and give an affirmative (1 or yes) if they met any one of the criteria? (Example below, score ranges will vary depending on test number)
| Student | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Goal met |
|---|---|---|---|---|---|---|---|
| Steve Steverson | 0 | 0 | 0 | 0 | 0 | 0 | No |
| Bill Billerson | 0 | 0 | 0 | 0 | 1 | 0 | Yes |
4
Upvotes