http://chandoo.org/forum/threads/subtotal-with-sumif.36629/
In the attached sample file.
Sum value of qty of machines required to come sheet "Costing"from cell range E5:E244 against each machine type given in sheet "Investment" in corresponding year 2019 to 2024.
Value should get automatically change according to filters applied in sheet "Costing".
What is the correct excel formula to be used?
In the attached sample file.
Sum value of qty of machines required to come sheet "Costing"from cell range E5:E244 against each machine type given in sheet "Investment" in corresponding year 2019 to 2024.
Value should get automatically change according to filters applied in sheet "Costing".
What is the correct excel formula to be used?
