How to use countif / countifs with references, where parent rows are excluded.


I am trying to make a separate sheet to my main grid-sheet. In this separate sheet I want to count certain metrics.

for instance; I want to have an overview of the amount of tasks and in what status they are.

Initially I used this formula:

=COUNTIF({Planning area 80, 60 & 10 rev1 Range 1}; ="Completed")

The problem is this formula includes parent rows. My parent rows themselves aren't tasks, so I don't want them included. Also, when using references the cells have to be next to each other, so I can't just pick the cells I want.

Is there a way to exclude the parent rows?

Thank you in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!