'How to sum up values in excel based on two different conditions?
I have the following data in excel. As you can see above each ArchID/ConopsID is linked to different FY and in each FY there are different tiers. I am trying to find a way where if tier is 1 or 2, the value stays the same. However, if you see ArchID = 700 only goes up to tier 3 whereas ArchID = 300 goes to tier 4. I want if an ArchID only goes up to tier 3, we take the value shown on tier 3 but if tier 4 is present, then we add up (sum) the value of tier 3 and 4 and insert that as the new value.
For example, for ArchID = 322, in FY 2022, the new value displayed in tier 3 should be 8 (2 + 6). Where as for ArchID = 700, in FY 2022, the value displayed in tier 3 would stay at 5 since there is no tier 4.
Please let me know how I can solve this.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|