CODEWITHSUNDEEP
excelexcel-formula
Djhans26
Djhans26

Reputation: 79

Trying to do sumifs formula that calculates multiplication as well

I have a Sumifs formula that i am trying to have the sum range be multiplication between two columns. It is giving me an error stating "There's a problem with this formula. Not trying to type a formula? etc." My formula looks like this:

=sumifs(sum($I$4:$I$32*$C$4:$C$32),W3,$E$4:$E$32)

What is wrong with this formula?

Upvotes: 0

Views: 87

Answers (1)

Djhans26
Djhans26

Reputation: 79

By using the sumproduct function, I can achieve my goal with the formula looking like:

=SUMPRODUCT(I4:I32,C4:C32*(E4:E32=W3))

Upvotes: 2

Related Questions