SUMIF of CHILDREN on Different Sheet
I want to create a roll-up summary sheet from data on another sheet.
The source sheet/data, let's call it "Pricing":
The summary sheet, lets call it "Summary":
What formula can I use to grab the Cost and Price from each Store # on the Pricing Sheet and automatically populate the Summary Sheet?
I imagine it's some combination of SUMIF and CHILDREN.
Help Article Resources
Check out the Formula Handbook template!