Circular issue with countifs formula
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?
Best Answer
-
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
Answers
-
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
-
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
-
Fantastic! Glad it worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!