Multi Step Formula - Monthly Counts

Monica Gallegos

I'm trying to create a metric sheet that looks at multiple values, and records that info in a cell each month.

If I have 5 members join membership A, in October 2020 it would count the member type + number of members in the month of October 2020. Once I nailed down the proper formula I would apply it starting Jan 2019.

I was thinking a COUNTIFS would be the way to go, but I'm not able to figure out the year component. This is what I have so far:

=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, [{ERG MEMBERSHIP Joined Date}, 12 / 0 / 2020])

I assume it's the date portion I have incorrect. Any suggestions?

Thanks

David Tutwiler

If you're looking to count by month it would be:

=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10)

This formula assumed the Joined Date is in the Date format and that the month you're looking for is October (the 10th month).

David Tutwiler

If you're looking to count by month it would be:

=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10)

This formula assumed the Joined Date is in the Date format and that the month you're looking for is October (the 10th month).

Monica Gallegos

Hi David

Thanks for that feedback! The adjustment you provide worked well. I also added in the year and sharing the final formula incase someone out there needs it.

=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10, {ERG MEMBERSHIP Joined Date}, YEAR(@cell) = 2020)

Thanks again!

David Tutwiler

No problem. Glad it is working.