Previous month count should stop when we enter the current month

Khasim

Hi,

Is the following test case possible?

I have "four phases" available in the "AppliedPRO column"; I want to automatically count the phases for each month, but my previous month count should stop when we enter the current month.

I hope this test case is useful to other users as well

Thanks

Paul Newcome

You could always include date range/criteria sets in your formula.

Khasim

Hi @Paul Newcome @Paul Bassett Can you give me an example?

Paul Newcome

Cumulative leading up through June of 2022:

=COUNTIFS({Complete Date}, @cell <= DATE(2022, 06, 30))

June of 2022 only:

=COUNTIFS({Complete Date}, AND(IFERROR(YEAR(@cell), 0) = 2022, IFERROR(MONTH(@cell), 0) = 6))

Khasim

Hi @Paul Newcome Thanks for the quicks response. It will work if we have a date. However, in our case, it is a phase.

As an example, consider the following: We have four phases in the AppliedPRO, and I have to count them each month. If we move to the next month, the current month count should be frozen.

I hope you understand my test case.

Paul Newcome

I'm not sure I understand how data is being populated in your screenshot.

Khasim

Hi @Paul Newcome I used a cell link that came from an individual sheet.

Paul Newcome

What type of data is being brought in?

Khasim

Hi @Paul Newcome It's dropdown values (from Individual Sheet) and cell linked to the Master Sheet.

Paul Newcome

How are the columns on the right being populated?