#### Actuariojf

##### New Member

- Joined
- Aug 29, 2002

- Messages
- 15

Given:

Column A Column B

A1 = 1 B1 = 10

A2 = 2 B2 = 11

A3 = 3 B3 = 12

A4 = 4 B4 = 14

I would like to get a excel function or procedure that I will input JUST ONCE on C1 and copy down to C2..C4 with the following results:

C1=A1*B1=1*10=10

C2=A1*B2+A2*B1=1*11+2*10=31

C3=A1*B3+A2*B2+A3*B1=1*12+2*11+3*10=64

C4=A1*B4+A2*B3+A3*B2+A4*B1

=1*13+2*12+3*11+4*10

= 110

It seem easy, but it is not. Try to do it and please somebody help me!

Thanks!

This message was edited by Actuariojf on 2002-08-30 10:50