Acct | Name | Return |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
123 | John | .25 |
<tbody>
</tbody>
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 #.