Check count by project type AND how many started that month
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!
Best Answer

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 2381, 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!
Answers

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 2381, 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, 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!
Help Article Resources
Categories
Check out the Formula Handbook template!