Formula to Use
I'm trying to figure out how to write a formula that would add the numbers in the "QTY" column that also match the selected "Replace in Fiscal Year" dropdown selection. The top rows 24-29 is where the totals would populate based on the matching of the "Replace in Fiscal Year" selected and "QTY" sum in the corresponding cell.
Help Article Resources
Check out the Formula Handbook template!