Sum 3 Column in the left in Excel

Help Activities
, , ,
1

Hello All,

Currently i’m developing RPA to generate report monthly and need to add additional column each 3 month (Quarterly).

For Example expected.
image

But there is some case if manually using excel formula to achieve this case.

  1. the column is generic append to the right of empty column (ex : Jan=D2, Feb=E2, Mar F2)
  2. The first column start with 3rd mont (March)
    image

is there any idea to solve this issue?

Regards,

2

you mean you want jan/feb column to be appended before Mar column? is this the issue?

3

Dear @jack.chan ,

sorry if i mistaken to inform,
no need to appended col jan/feb before mar.

i need to sum 3 column in the left but with additional validation, check if the 3 column left is column of month, not col Name.
if 3 column in the left only find 2 month (feb&mar), i need only sum 2 col left (feb&mar)

Regards,

1 Like
4

uipathF.xaml (20.4 KB)

@aliaga use my sequence
result 2 ( multiple columns example)
image

result 3 ( 1 column example)
image

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.