Forum Discussion
urpreeto
Jul 21, 2022Copper Contributor
How to organise Attendance data if it is in the single cell.
Hi, for our NGO, we get the students attendance data in a particular format from the App. The rows have following values - Date - Subject - Volunteer - Students' names & Present/Absent (this st...
OliverScheurich
Jul 21, 2022Gold Contributor
=SUMPRODUCT(($E$5:$E$12=D$15)*ISNUMBER(SEARCH($C16,$G$5:$G$12))*ISNUMBER(SEARCH($C$14,$G$5:$G$12))*(MONTH($D$5:$D$12)=$B$14))Does this show what you want to do?