i want to add all L6121 ,whose coreponding value is in NET BBLS
and L6511
sort_Excel.zip (655 Bytes)
here is the excel file
Please refer this…!
Thanks!
@ashishmani - you can build a datatable as a result of Read Range activity.
and then filter the datatable with L6121 and L6511 values (keeping only NET BBLS column) and then sum up all the values.
Let me know if you need more help.
can u make xaml for clear explaintion
plzz explain more
Hi ashishmani,
Probably there are other ideas but i will do it like
If row(3).equals(“L6121”)
Then
Sum
Else
If row(3).equals(“L6511”)
Then
Sum
GroupByColumnSumUp.zip (3.1 KB)
Thanks!
thanks… its working…
thanks. helpfull activity…
1 Like