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

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

• ✭✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭
edited 10/07/20
Options

@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.

• ✭✭✭✭✭✭
Options

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")

• ✭✭✭✭
Options

@Paul Newcome thanks! That worked!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!