Forum Discussion
Solved
Count how many times 1 column AND multiple columns (using OR logic) show up
Excel file attached. I want to know how many times a 7th grader showed up AT LEAST ONCE to the 4 dates showing (and then the same for 8th graders). It would be nice to expand the logic to how man...
=SUMPRODUCT(($B$3:$B$28=$O7)*($I$3:$I$28=P$6))With the results from column I you can try this formula.
=SUMPRODUCT(($B$3:$B$28=$O7)*($I$3:$I$28=P$6))With the results from column I you can try this formula.