SUMIF using children in a Column


I'm trying to get the Sum of the Yield column but I want it broken down by County name in a Sheet Summary.

This is the formula I tried but its coming back #UNPARSEABLE:

=SUMIF(Children(County:County, ="Lee", Yield:Yield))

Any ideas? Can it even be done that way?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!