Sum Dynamic Columns With same Month

Help Studio
, ,
1

Dear All,

My Scenario is to sum the column with same month over year.
Eg.xlsx (13.5 KB)
How Should I Approach to get the result? Thanks a lot.

1 Like
2

Hey @Sa_Ge

That means you need to sum all January column values into one ?

Thanks
#nK

1 Like
3

yeah for all month if has same month column sum that column thanks.

1 Like
4

Hey @Sa_Ge

So can you provide an output sheet as well which show the results for 2 to 3 months which will help us understand and build better logic.

Thanks
#nK

1 Like
5

Hey @Sa_Ge

Because do we need to sum it column wise or row wise is bit confusing.

Sorry for that.

Thanks
#nK

1 Like
6

I hope this clarify thanks a lot.
Eg 2.xlsx (12.0 KB)

The scenario is like data comes with dynamic column of years and months separate between Quantity and Amount. the expected result is to combine years data by each month for both Quantity and Amount each. It is quite confusing process for me. Thanks a lot for the help tho. appreciated it.