Check count by project type AND how many started that month

amyk

Hi,

I'm trying to run a formula that would count how many projects were completed in a specific month and the column named "Tier" had the value of "Tier 3" but I can't seem to adapt the below successfully to include both conditions i.e. number of tier 3s completed in Jan

=COUNTIF([Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

=COUNTIF(Tier23:Tier81, CONTAINS("Tier 3", @cell))

Any ideas on what would work here would be greatly appreciated!

Nick Korna

Hi @amyk

This should work to count the completed projects in a month:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

Hope this helps!

Nick Korna

Hi @amyk

This should work to count the completed projects in a month:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

Hope this helps!

amyk

Nick, thank you so much! That worked perfectly, I should have asked 3 hours ago!

Thanks for also provided the general formula outside of my selected rows :) super helpful!