•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Multiplying a colum by the dynamic sum of other columns...for multiple rows in one cell
Hi, I am trying to multiply amounts by percentages that accumulate over time.
For example in the table below: how much did I pay total by the end of year 2 (including year 1) for all the items. Same for year 3...
I have way too many items to do it manually! I am guessing it will be some kind of sumprod but can't figure out how to formulate it! To make things even more interesting, I have a condition to add to pick only some of the items (for example: calculate only for the items having the word "wood" in it).
| Item | Cost | Percentage paid year 1 | Percentage paid year 2 | Percentage paid year 3 | Percentage paid year 4 |
|---|---|---|---|---|---|
| 1 | 4 000 $ | 5% | 10% | 25% | 60% |
| 2 | 5 000 $ | 10% | 15% | 20% | |
| 3 | … | … | … | … | … |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#dynamic sum
#percentages
#percentage paid
#year
#multiplying
#cost
#sumprod
#items
#total
#table
#calculate
#wood