Circular issue with countifs formula

Anne-Solene Monrouzeau

Hi,

I have a circular issue with the formula below:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], >0)

I tried this, same issue:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], NOT(ISBLANK(@cell)))

I am trying to count the number of clients going live per month, for each row that is not blank.

Any idea what's going on?

Anne-Solene Monrouzeau

Hi Heather,

The issue was that the formula was in one of the column called out in the formula. It works now! Thanks,

Anne-Solene

Heather Duff

Hi @Anne-Solene Monrouzeau ,

What column is this formula being placed in? If it's being placed in the Actual Go Live Date column, Hierarchy column, or the Guardian Client column, it won't work because these columns (in their entirety) are included in the formula. If it's in one of those columns, it gets confused because it's trying to "count itself."

Hope this helps!

Best,

Heather

Anne-Solene Monrouzeau

Hi Heather,

The issue was that the formula was in one of the column called out in the formula. It works now! Thanks,

Anne-Solene

Heather Duff

Fantastic! Glad it worked.