SUMIF using children in a Column

sean.hagan1088

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?

Jeremy C

@sean.hagan1088

Have you tried using =Sum(Children) in the Yield cell of the parent line to get the totals for each County and then run a summary?

sean.hagan1088

@Jeremy C

I did and it works when I have that there, but they aren't wanting the totals on the sheet if at all possible and would like them in the sheet summary.

Jeremy C

@sean.hagan1088

If they don't want to 'see' the numbers there you could change the font color to match the background/fill color. Unfortunately I haven't used the sheet summary functionality so I'm not much help there.

sean.hagan1088

@Jeremy C let me give it a try and see. Appreciate your help!!