Sumifs formula for children rows if meet a certain criteria (using sheet reference)

Options
Crystal Panning
Crystal Panning ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi,Β 

I am looking for a formula to use in my metric sheet to sum the children rows that meet a certain criteria. I have tried everything I could think of and have had no luck. I have my source sheet with the parent/children rows, and then a separate metric sheet I am using to put the formulas in and referencing my source sheet. Do I need to add some helper rows to my source sheet to do this?Β 

I need to sum the children rows in Column A, if the criteria in the grandchildren rows (column B) = X

Β 

Any help is appreciated.Β 

Thank you,

CrystalΒ 

Comments