how to summerise values from specific columns

[AA Arens]

Hi,

I have tried to find the right formulah, but failed.

I have three column

Amount A Amount B Amount C
30
10 20
34

and a fourth column where I have to fill in % that applies to all
values A-C in the row.

12%
45%

How to make a formula in a cell that summerise all amount A's * the
respective %

For example:

30 * 12% + 10 * 45% =


Also for two other cells for B and C

Bart

Vista/excel 2007

 

[Sebation]

try sumproduct()
=SUMPRODUCT(A2:A3*D23)
HTH

Regards
Sebation

 

[Bob Phillips]

=SUMPRODUCT(A2:A4,$D$2:$D$4)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[AA Arens]

try sumproduct()
=SUMPRODUCT(A2:A3*D23)
HTH

Regards
Sebation

Thanks Sebation, that did the job.

Bart