How to do this total?

  • Thread starter Thread starter shawn
  • Start date Start date
S

shawn

I am using Office 2007, but save my files in the older format for others.

How do I do this formula?

In Column D I have prices. Right now it goes D16 - D285. In Column E I put
the quantity I sent to someone. At the bottom I want a total $$.

So, for example: if E16 = 1 then check price in D16 and add to total. If E17
= 2 then check price in D17 and add to total twice, etc. all the way down.
 
I would add another column to your data (say column F)

I'd label it Extended Price.

And I'd put:
=d16*E16
(and drag down)

Then I could use:
=sum(F16:F285)

=====
But if you don't want that extra column:
=sumproduct(d16:d286,e16:e286)

It multiplies each row and then sums those 271 products.
 
Got it guys, thanks a bunch. Yeah, I used to have Extended Price on my old
worksheet, but on this one I won't be using that column. The file is used to
make sample invoices to our sales reps. 99% of the time we only send them 1
of each sample, so that column is kind of useless.
 
I always liked having that extended price in the worksheet. If I never used it,
it was ok. But every once in a while....
 
Back
Top