How to do this total?

[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.

 

[Bernie Deitrick]

=SUMPRODUCT(D16285,E16:E285)

HTH,
Bernie
MS Excel MVP

 

[Dave Peterson]

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.

 

[shawn]

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.

 

[Dave Peterson]

I always liked having that extended price in the worksheet. If I never used it,
it was ok. But every once in a while....