CODEWITHSUNDEEP
excelexcel-formula
NCC
NCC

Reputation: 819

How to do product of sum with Excel

enter image description here

I would like to have the result by 1 formulas in the cell next to "TOTAL"

Right now I have to:

  1. SUM(QTY1, QYT2, QTY3)*Price on each row
  2. SUM

Is there anyway to get the final result with 1 step something like SUMPRODUCT(PRICE, SUM(QTY1,QTY2,QTY3))?

Upvotes: 0

Views: 2859

Answers (2)

Howard
Howard

Reputation: 39177

You may decompose the formula into

SUMPRODUCT(PRICE, QTY1) + SUMPRODUCT(PRICE, QTY2) + SUMPRODUCT(PRICE, QTY3)

or use

SUMPRODUCT(PRICE, QTY1 + QTY2 + QTY3)

directly (PRICE, QTY1, ... are the names of the regions shown in your example) .

Upvotes: 2

JohnB
JohnB

Reputation: 13713

Maybe

SUMPRODUCT(Price*(QTY1+QTY2+QTY3))

Sorry, I cannot try it at the moment.

Upvotes: 1

Related Questions