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 123 views

## 1 answer to this question.

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.

• 52,760 points

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

The (account name) test1 100 euro #mountain ...READ MORE

## Protect excel sheet but allow data entry with form

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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