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 - 13 Sep 2007 09:35 GMT
try sumproduct()
=SUMPRODUCT(A2:A3*D2:D3)
HTH
Regards
Sebation
"AA Arens" <bartvandongen@gmail.com>
??????:1189666230.322812.67490@50g2000hsm.googlegroups.com...
> Hi,
>
[quoted text clipped - 25 lines]
>
> Vista/excel 2007
AA Arens - 13 Sep 2007 12:48 GMT
> try sumproduct()
> =SUMPRODUCT(A2:A3*D2:D3)
[quoted text clipped - 34 lines]
>
> > Vista/excel 2007
Thanks Sebation, that did the job.
Bart
Bob Phillips - 13 Sep 2007 12:12 GMT
=SUMPRODUCT(A2:A4,$D$2:$D$4)

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Hi,
>
[quoted text clipped - 25 lines]
>
> Vista/excel 2007