Summary data 2 sheet?

I have 2 sheet (CE, CC)
I want to sum value from sheet CE and CC by refer column F (Company_Group)
image

and add new sheet summary as below.
company_group have 5 rows.

Please guide me for solve it.
input.xlsx (16.9 KB)

Hi @fairymemay

In the output we can see that RA BCV_Amount is looking different can you confirm about this

Hi @fairymemay

BlankProcess3.zip (53.1 KB)

Use write cell and autofill activities

=SUMIFS('CE'!D2:D4, 'CE'!F2:F4, C2) + SUMIFS('CC'!D2:D5, 'CC'!F2:F5, C2)
=SUMIFS('CE'!E2:E4, 'CE'!F2:F4, C2) + SUMIFS('CC'!E2:E5, 'CC'!F2:F5, C2)

Hope it helps!!

1 Like

Sheet summary don’t have.
I want create by UiPath.

@Dinesh_Guptil

RA BCV_Amount from sheet CC (13+54 = 67 ) and sheet CE = 1
summary = 68
image
image

can you guide me about it.

hey , @fairymemay
Sum_2 datatables.zip (14.4 KB)

Check this out
Hope it helps you out

1 Like

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