•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
Our take
If you're looking to efficiently calculate the total payments for items over multiple years, using a formula that incorporates dynamic sums can simplify the process significantly. By leveraging functions like SUMPRODUCT, you can multiply costs by accumulated percentages while applying criteria, such as filtering for items containing "wood." This approach allows you to avoid manual calculations and streamline your data analysis. With the right formula, you can effortlessly track your total expenses for each year, ensuring accuracy and saving you valuable time.
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]
Read on the original site
Open the publisher's page for the full experience