counting the number of people that attended a meeting on any date

System

This discussion was created from comments split from: countif with dates.

SarahML

I'm trying to do something similar where I am counting the number of people that attended a meeting on any date but I am also looking at it by cohort (2020-2021 vs anything previous). I've gone through many of these threads and tried to piece together the different codes but it's not working for me.

This is the formula I'm using and it references the columns from one other sheet:

=COUNTIFS({20-21 AET Sept VC}, (IFERROR(YEAR(@cell), 0) >= 2020), AND({AET ET Cohort}, ="2020-2021") / Total@row)

Paul Newcome

@Sarah Lanahan What data exactly is in this range {AET ET Cohort}?

SarahML

@Paul Newcome It's text of the school year the joined our program. So 2020-2021 for new instructors, and returning instructors is from 2019-2020, 2018-2019, 2017-2018, etc.

Paul Newcome

Ok. Then we should only need to do some restructuring of your current formula. Try this...

=COUNTIFS({20-21 AET Sept VC}, IFERROR(YEAR(@cell), 0) >= 2020, {AET ET Cohort}, ="2020-2021")

SarahML

@Paul Newcome thanks! That worked!

Paul Newcome

Happy to help. 👍️