# Sum then Product

#### skrappy

##### New Member
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?

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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"

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
ABCD
10.05
20.06
30.07
40.1
50.05
65.33
7
Sheet1

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?

Replies
4
Views
247
Replies
6
Views
377
Replies
4
Views
235
Replies
2
Views
184
Replies
9
Views
166

1,221,207
Messages
6,158,529
Members
451,497
Latest member
something68

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back