I have a Google Sheet that I use to track attendance at an open lab that I run. Each quarter I put together a report where I count the number of people that attended that quarter. If I just use the count function I could include people that only attended the first quarter in the second quarter report or that attended the second in the third.
I want a way to say, "if this person attended between these dates then count them."
For example, in the picture I attached
Name 2 only attended during the first quarter so they wouldn't be included in the second quarter count.
Name 5 attended during both so they would be included in both counts.
My best idea for putting this into Google Sheets is
or in other words count the names if they attended during the first quarter. Is there any way to do this?
Edit: Here's a link for the spreadsheet:https://docs.google.com/spreadsheets/d/1SwukY3SsjWfYyu2RakED0S0V4kZwRfNN0nVoDsKMN5A/edit?usp=sharing
Doing this manually there should be 38 people that attended during the first quarter and 42 that attended the second.