How to Apply Filters in One Row that Adjusts Price in Another
I have a sheet that tells me the price of a product based on whether it's "Completion" is checked or not. I need to be able to filter the "Position" column to show me "Only Angle A" or "Only Angle B" etc. AND, I need the "Price" column to adjust appropriately when these filters are applied. The idea is that if we only want to capture product "Angle A", the price should adjust down with that filter.
The formula in each row under "Price" is: =IF(COUNT(CHILDREN()) = 0, IF(Completion@row = 1, 0, 47.5), SUM(CHILDREN()))
Please let me know if you can help!
Help Article Resources
Check out the Formula Handbook template!