COUNTIF as of Today?

Jack Parry

Hi, I have a sheet I'm using to calculate the number of open tasks on my project.

=COUNTIFS({Corporate MOC Location}, CONTAINS("BER", @cell))

The reference sheet is constantly being updated as and when actions are completed.

I want to cell link this count to my KPI sheet to track the performance of the team over the course of the year. e.g how many open actions were left open in July, August, etc.

Is there a way of adding to my formula to only make it look at the number of open tasks up to the last day of the month.

I'm probably overthinking this..

Paul Newcome

Do you have a date in the source sheet that shows when each item was closed?

Jack Parry

@Paul Newcome, potentially I can add this.

Are you thinking of referencing this column in my formula and then adding <= of the last day of the month?

Paul Newcome

Its either that or you are going to have to incorporate a third sheet and use a copy row automation.