Rolling Multiplication Problem

[bgates]

Hi,

I hope someone can help me with the following problem.

..... A B C D
100 .. 1 2 N1
101 3 4 5 N2
102 6 7 8 N3
103 9

I want to do this:

1 * 2 * 3 = N1; then:
4 * 5 * 6 + 1 * 5 * 6 = N2; then:
7 * 8 * 9 + 4 * 8 * 9 + 1 * 8 * 9 = N3; etc.

Does this require some kind of macro and if so, where might I find an example?

Thanks in advance.

Bill

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

Refer my signature area to know how to attach file

[bgates]

Hey Sixthsense,

Here's an example for you. I hope this is clearer!

Cheers,

Bill

[:) Sixthsense :)]

Not sure what is your expectation

[bgates]

As you can see from my example, I have to keep adding to the formula in order to get the desired result. I'd like to change the formula in row 1 so it keeps looping when I need to drag it down as more rows of data are added. Hope this is clearer.

[shg]

Please Login or Register  to view this content.

[bgates]

Thanks shg, works like a dream! Nice use of math too!

Bill

[shg]

You're welcome.