Counta & Multiple Conditions
Posted by Tom Boyd on February 13, 2002 7:36 AM
I haven't been able to figure this one out.
A B C D E F G H I J
1 1 2 3 4 5 6 7 8 9
2 A x x x x x
3 B x x x x x x
4 C x x x x x x
The rows represent attendance at events 1-9. An X indicates attendance. I need a column with a "yes" or "no" for each row, indicating whether the attendance goal has been met.
The goal is complicated, so bear with me:
-Attendance at ONE of either event 1 or 2 is mandatory
-Only events 3,5,7&8 count toward the goal (the others are used for a different formula)
-1/2 of these 4 events must be attended
Thanks in advance!