I want to sum a range but i want to choose for every instance which column the next number comes from based on a criteria. for example: if the user has a member account, sum cost and tax, if they have a seller account , only sum cost. where cost is stored in column a, cost with tax in column b and their account status is stored in column c.
basically, I need my sum function to choose between two cells based on a criteria like a sumif but instead of either including or not including a cell it chooses which cell to include
basically, I need my sum function to choose between two cells based on a criteria like a sumif but instead of either including or not including a cell it chooses which cell to include
