Ignore Summary Task When Counting Late Tasks
I use the formula when counting late tasks: =IF(ISBLANK(Finish107), "", IF(AND(TODAY() > Finish107, [% Complete]107 < 1), 1, ""))
The issue with this is that it also counts summary tasks which really aren't tasks themselves. Is there a way to ignore summary tasks so I don't have to manually delete the formula in the cell in the Late Task column?
Comments

You could use the Children Function to only include children in the column.

That makes sense. Would I take out the ISBLANK and replace with Children? How would I start the formula?

Try this, I have not written a lot of formulas counting children, but this might work. Try putting it in your parent row, and then sum that column to get a total count.
=Countifs(Children(), (TODAY() > Finish107, Children(), [% Complete]107 < 1)

How would you Count the total tasks in a Column and still ignore the Summary Tasks? In this formula, I only get a single child in the first row.
=COUNT(CHILDREN({Avanade Onboarding Tasks Range 4}))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!