I have 2 sheet (CE, CC)
I want to sum value from sheet CE and CC by refer column F (Company_Group)
and add new sheet summary as below.
company_group have 5 rows.
Please guide me for solve it.
input.xlsx (16.9 KB)
I have 2 sheet (CE, CC)
I want to sum value from sheet CE and CC by refer column F (Company_Group)
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!!
Sheet summary don’t have.
I want create by UiPath.
RA BCV_Amount from sheet CC (13+54 = 67 ) and sheet CE = 1
summary = 68
can you guide me about it.
hey , @fairymemay
Sum_2 datatables.zip (14.4 KB)
Check this out
Hope it helps you out
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.