Parent/Children Formulas with Date Ranges
Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet?
I have several count ifs, and sum ifs all corresponding to the month and the year. The parents and children will all have the same metrics and hierarchy for multiple suppliers.
The first formula is a COUNTIF, the supplier name matches the Parent, and the row was created in month 1 of year 19.
The second formula is SUMIF, the supplier name matches the Parent, and the rows were created in month 1 of year 19 ... etc.
Any advice would be most appreciated.
Help Article Resources
Check out the Formula Handbook template!