Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
I am using SumProduct to identify the row that I want to get values from and the columns to create a "right" limit. Now I want to add everything from left to right and drag it left to get the value change.
I am going to try and show what I have below:
Table 1
Table 2
I want to make table 2 update if I change Table 1.
I have been using sumproduct to find my Total Days, but I cannot figure out how to do the dynamic ranger for Operation #'s.
Thank you!
I am going to try and show what I have below:
Table 1
Program | Operation 1 | Operation 2 | Operation 3 | Operation 4 | Operation 5 | Total Days |
Program Name 1 | 5 | 10 | 12 | 18 | 25 | 70 |
Program Name 2 | 3 | 9 | 14 | 15 | 18 | 59 |
Table 2
Program | Operation 1 | Operation 2 | Operation 3 | Operation 4 | Operation 5 | Total Days | ||
Program Name 1 | Total Days = 70 | Total Days - Sum(Operation 1:Operation 1) = 65 | Total Days - Sum(Operation 1:Operation 2) = 55 |
| Total Days - Sum(Operation 1:Operation 4) = 25 | 70 | ||
Program Name 2 | Total Days = 59 | Total Days - Sum(Operation 1:Operation 1) = 56 | Total Days - Sum(Operation 1:Operation 2) = 47 |
| Total Days - Sum(Operation 1:Operation 4) = 18 | 59 |
I want to make table 2 update if I change Table 1.
I have been using sumproduct to find my Total Days, but I cannot figure out how to do the dynamic ranger for Operation #'s.
Thank you!