Excel Calculations_03

Help Studio
, ,
1

Hello guys i have an excel like this

I want to read the excel and perform the following task.

image
image977×653 26.9 KB

Here i want to add the value of corresponding year of claims column marked in yellow

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,

Test Data.xlsx (10.9 KB)

2

I don’t understand your question - could you please clarify what you need help with, as your formulas in Excel look correct.