Not sure what to title - SUMIF but a lot harder?

[megera716]

Sorry I don't even know what to title this. I had to exclude some of the data for anonymity, but this should be all the info necessary to do what I need.

I have a list of products, some of them are in groups and some are not (I highlighted two groups yellow and blue for ease). If they are in a group, I need to sum the value from the Minimum column of only the Children from Column D, but put it on the Parent line that has the same Group ID from column B. See screenshot below. if Column D is blank (which it is, around row 500 and down), then Column AK should pull the number from Column AJ.

I typed these numbers in by hand for what it should look like, but my data is over 2,000 rows so obviously not a practical solution for the entire sheet.

Thanks!

 

[barry houdini]

Try this formula in AK2 copied down [revised]

=IF(D2="Child","",IF(D2="Parent",IF(COUNTIF(B:B,B2)>1,SUMIFS(AJ:AJ,B:B,B2,D:D,"Child"),AJ2),AJ2))

 

[megera716]

Try this formula in AK2 copied down [revised]

=IF(D2="Child","",IF(D2="Parent",IF(COUNTIF(B:B,B2)>1,SUMIFS(AJ:AJ,B:B,B2,D:D,"Child"),AJ2),AJ2))

This got me part of the way there! Your formula returned a 0 on the rows that were a parent with no children (basically all of the rows EXCEPT the yellow and blue ones from my screenshot). I think it's because the second part says If D is a parent (true), then SUMIF with one of the criteria being "Child", but there are no children to sum on those lines. But since the argument returned true, it doesn't look at AJ for a result.

 

[barry houdini]

Yeah, I realised that was wrong and edited - if you try the version shown now that should work for all rows

 

[megera716]

Yeah, I realised that was wrong and edited - if you try the version shown now that should work for all rows

PERFECT, thank you!!!!