trying to multiply values based on criteria, not sure sumproduct will work or not

[dtslater]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Acct[/TD]
[TD]Name[/TD]
[TD]Return[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]John[/TD]
[TD].25[/TD]
[/TR]
</tbody>[/TABLE]

I have a long list I'm trying to apply this formula too but cannot figure it out. I need to multiply the records in the Return column based on the Acct. I was able to use {=PRODUCT((E952:E963/100)+1)} on just the Return column to get the number I want. How can I take that formula, or similar formula, and apply the criteria of the account number? My data contains ~1000 rows and each client has 12 months so I need a formula I can drag down that will multiply the cells but only for a specific account #.

 

[sheetspread]

This is sort of what you want:

Excel 2010
	A	B	C	D
1	Acct	Name	Return
2	123	John	0.25	11.64153218
3	123	John	0.25	11.64153218
4	123	John	0.25	11.64153218
5	123	John	0.25	11.64153218
6	123	John	0.25	11.64153218
7	123	John	0.25	11.64153218
8	123	John	0.25	11.64153218
9	123	John	0.25	11.64153218
10	123	John	0.25	11.64153218
11	123	John	0.25	11.64153218
12	123	John	0.25	11.64153218
13	456	Jim	0.35	36.64419807
14	456	Jim	0.35	36.64419807
15	456	Jim	0.35	36.64419807
16	456	Jim	0.35	36.64419807
17	456	Jim	0.35	36.64419807
18	456	Jim	0.35	36.64419807
19	456	Jim	0.35	36.64419807
20	456	Jim	0.35	36.64419807
21	456	Jim	0.35	36.64419807
22	456	Jim	0.35	36.64419807
23	456	Jim	0.35	36.64419807
24	456	Jim	0.35	36.64419807
Sheet9

Cell Formulas
Range	Formula
D2	{=PRODUCT(IF($A$2:$A$24=A2,1+$C$2:$C$24))}
Press CTRL+SHIFT+ENTER to enter array formulas.

Not sure why you're dividing by 100 when the .25 is already a decimal (basis pts perhaps ???) but that's easily adjusted in the formula.

Another way is to add 1 to each cell with copy/paste special and create a pivot table with product as the value field setting.

 

[dtslater]

Outstanding. This is perfect!