I am trying to create small chart for dashboard

Weston

I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample

Jan 2022 - 4

Feb 2022 - 3

Mar 2022 - 4

Etc...

Paul Newcome

You would need to create a table in a sheet and have each label in a single column. From there you can use COUNTIFS formulas to get your counts.

=COUNTIFS({Source Sheet End Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022))

Weston

I get unparsable can you give me an example if I ask kindly?

Paul Newcome

My last post is the example. Are you able to provide some screenshots for reference?

Weston

A bit more cleanup

Weston

Is there a way to filter out a third, ie I don't want completed projects.

Paul Newcome

To include another range/criteria set in a COUNTIFS, you would follow the same syntax of range comma criteria.

=COUNTIFS({Source Sheet End Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022), {Range 2}, criteria 2)