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
• 38,000 points
1,285 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
• 63,600 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
• 63,600 points
1,157 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
• 63,600 points
738 views
0 votes
0 answers

Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

from instabot import Bot import openpyxl import smtplib bot = ...READ MORE

Sep 26, 2022 in Others by Kithuzzz
• 38,000 points
837 views
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
• 63,600 points
1,592 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,690 points
4,107 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,690 points
2,009 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,690 points
988 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
• 23,260 points
3,717 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
• 63,600 points
2,462 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
• 63,600 points
1,118 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