Creating a count for a Column

nick.wilson

So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working and I am not the best with them. Can someone help me figure this our?

Paul Newcome

Yes, you would add another range criteria set to the existing COUNTIFS structure.

=COUNTIFS([Completion Date]:[Completion Date], IFERROR(YEAR(@cell), 0) = 2023, Status:Status, @cell = "In Progress")

Paul Newcome

Assuming the [Completion Date] column is a date type column hosing date type data, give this a try:

=COUNTIFS([Completion Date]:[Completion Date], IFERROR(YEAR(@cell), 0) = 2023)

nick.wilson

That worked, but now I have one more question. Is it possible to create a similar formula that shows all the projects that are "In Process" within my Status column?

Paul Newcome

Yes, you would add another range criteria set to the existing COUNTIFS structure.

=COUNTIFS([Completion Date]:[Completion Date], IFERROR(YEAR(@cell), 0) = 2023, Status:Status, @cell = "In Progress")

nick.wilson

that worked thx!

Paul Newcome

Happy to help. 👍️