I am needing help on a CountIfs Formula when referencing a parent row
I have this table that I am trying to count when a certain college has been completed if it has a signed partnership (referencing the parent row). I am using this formula in the Summary Sheet. Does anyone have any idea how I can make this work? I am getting the following error when I try my formula: #UNPARSEABLE
=COUNTIFS(Status:Status, "In Progress", Alabama:Alabama, "IT College", MOU:MOU, PARENT("Signed Partnership"))
Where am I going wrong in this formula?
Answers
-
Have you tried:
=COUNTIFS(Status:Status, "In Progress", Alabama:Alabama, "IT College", MOU:MOU, PARENT(@cell) = "Signed Partnership")
-
I tried it and am still getting Unparseable
=COUNTIFS(Status:Status, "In Progress", Alabama:Alabama, "IT College", MOU:MOU, PARENT(@row) = "Signed Partnership")
-
The real holdup here is the fact that the MOU only exists on the parent row. Is there a reason that it can't be copied down to the child rows? It would make the counts much easier. In a test sheet I was playing in I used this formula to copy the parent to all of the children by pasting this formula in all of the child rows.
=IF(COUNT(ANCESTORS()) > 0, PARENT(), 0)
-
Thank you, it just looks more bulky when it is in all of the rows, but I think that is going to be the best way to get it done. I appreciate the help!
-
No problem. There still might be a way to get the formula to work with looking at the parent, but sometimes the helper columns are very convenient.
Could you potentially have a helper column that contains all of the copies of the parent and then hide it on the sheet but reference it with your formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!