Create formula for monthly count of extensions

asha.D

Currently tracking our active project extensions. If we get an extension in a particular month I want to be able to capture how many extensions we get within each month.

Matt Lynn ACT

@asha.D That is the correct formula but you're missing a comma between {month} and "Jan".

heyjay

=COUNTIFS(
{X}, "Yes", 
{Y}, 1, 
{Z}, "Jan")

Where:
X - Extension reference name

Y - Active Status checkbox

Z - Month

asha.D

Hello and thank you for responding to my post.

I tried the formula above for my Active project sheet and wasn't able to get retrieve the data correctly with the formula provided above. Does anyone have any feedback as to what I should change in my formula to be able to capture each month count of extensions?

Matt Lynn ACT

@asha.D That is the correct formula but you're missing a comma between {month} and "Jan".

asha.D

Awesome thank you, it WORKED!