Sum then Product

[skrappy]

Here is my situation. I a familiar with SUMPRODUCT, but I need it the other way around. I want an easy way to add two columns first then multiply the sums.

I have a column of percentages, I want to add 1 to each of these (i.e. to go from 5% to 1.05) and then take the product of all of these to get the total return.

Any ideas?

 

[paliman]

Try this:

=PRODUCT(range+1)

where "range" is the range where you have the percentages

To enter this formula hit ctrl+shift+enter, not just "enter"

 

[Jim North]

You mention two columns in the first paragraph... please provide more details.

The following does what you ask in paragraph two... is it what you want?

Book1
	A	B	C	D
1	0.05
2	0.06
3	0.07
4	0.1
5	0.05
6	5.33
7
Sheet1

 

[Aladin Akyurek]

On 2002-09-04 13:02, skrappy wrote:
Here is my situation. I a familiar with SUMPRODUCT, but I need it the other way around. I want an easy way to add two columns first then multiply the sums.

I have a column of percentages, I want to add 1 to each of these (i.e. to go from 5% to 1.05) and then take the product of all of these to get the total return.

Any ideas?

This is clearly a repost...

http://www.mrexcel.com/board/viewtopic.php?topic=20741&forum=2

which you left behind you... unresolved.

Why don't you give an example with expected hand-calculated results?