CODEWITHSUNDEEP
excelgoogle-sheetsspreadsheet
La faguette
La faguette

Reputation: 581

Sum multiple values in certain rows in a unique formula

I want to do a formula that multiplies 2 values on each row with the same ID (another value) of the row where the formula is. Like a sumproduct selecting only certain rows (by ID) in the range.

I shared the doc here so that you can understand what I need better. (The formula would be in the column "total" at it should automatically do what it's done in the column B)

Thanks

Upvotes: 0

Views: 69

Answers (1)

user4039065
user4039065

Reputation:

Adding a criteria for column E should be sufficient to cancel out the non-matching rows. In B6 use,

=SUMPRODUCT(($E$6:$E$13=E6)*($F$6:$F$13)*($G$6:$G$13))

Fill down as necessary.

Upvotes: 1

Related Questions