Hello guys i have an excel like this
Here i want to add the value of corresponding year of claims column
Means The green marked value is the sum of value of corresponding yellow marked year
Likewise, i want to get the sum of values for each year like 2020,2021,2022,2023,2024 only for claims column.
and the blue marked cell is the total sum of green cell.
So how can i achieve this,
I have edited your post because it contained what seemed like sensitive information.
Please be ware of attaching files that should not be made public, and use clearly stated mockups of the files instead of the real data.
The attached file only contains year and some value corresponds to that no other sensitive info
It also contained the names of the entities above those numbers, which is the reason why I removed it. Please be very careful with what you attach on a public forum.
It is completely fine to mock the numbers and the names and reattach such mockups 