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

0 votes

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?

Sep 29, 2022 in Others by Kithuzzz
• 28,520 points
123 views

1 answer to this question.

0 votes

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.

answered Sep 30, 2022 by narikkadan
• 52,760 points

Related Questions In Others

0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 52,760 points
171 views
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 52,760 points
117 views
0 votes
1 answer
0 votes
1 answer

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 52,760 points
254 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
211 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
380 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
173 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
158 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

answered Nov 13, 2022 in Others by narikkadan
• 52,760 points
89 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 52,760 points
147 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP