Forum Discussion
Solved
Excel formule
I have a question about excel. I have a list of old orders with the purchase price and the number of products sold that are all put in different categories. Now I want to use a form...
= SUMPRODUCT(($N$2:$N$20="Christmas inside tree")*$E$2:$E$20*$Y2:$Y20)Does this return the intended result?
= SUMPRODUCT((N2="Christmas inside tree")*E2*Y2)This formula calculates the result in every row. The formula is in cell W2 and filled down in the example.
= SUMPRODUCT(($N$2:$N$20="Christmas inside tree")*$E$2:$E$20*$Y2:$Y20)Does this return the intended result?
= SUMPRODUCT((N2="Christmas inside tree")*E2*Y2)This formula calculates the result in every row. The formula is in cell W2 and filled down in the example.