Excel use SUMIF but with a multiplier before summation x2 x3 x4 etc

Question

In a spreadsheet I have, the SUMIF function is being used. Single values from another column can be summed up remarkably well, however, I'd like to have the option of potentially multiplying a single entry's value beforehand.

Since I can't attach photographs, I'll try to describe them instead. I have this equation in my spreadsheet:

=SUMIF(L25:L31,"x",$K$25:$K$31)

The value from column K will be added to the sum if I place a "x" on a row in column L. I want to be able to multiply the value before the summing using the operators "x2," "x3," "x4", etc. Is Excel able to do that?

Answer 1

The product of the sum and the sum of the products are the same since multiplication is distributive. If I understand your query correctly, then you can relocate the multiplier to the outside of the equation. The following should work where "y" is the multiplier and "x" is the search criteria:

=y*SUMIF(L25:L31,"x",$K$25:$K$31)

If the multiple is a variable, then I would suggest adding helper columns and simply changing the sum range on the SUMIF formula.