Excel - Sum of values from certain lines

[RoboticApprentice]

Hey,

I have an excel list with 3 columns, one contains the customers, the second the information whether they receive a newsletter or not and the third the sales that the customer has generated in the last month.

I want to evaluate the total sales of customers who receive a newsletter. (Here the answer should be 50)
I would like this value to be output in a variable so that I can continue to work with it later.
Can someone help me?

Best wishes

[ArunVelaayudhanG]

Save it in data table.
Variable Sum = 0

For each row in data table,
if second column = Yes,
sum = sum + third column

print sum

[RoboticApprentice]

is it not possible to do it in one Assign function ?

[ArunVelaayudhanG]

if you can create the formula manually in excel, you can just use the same formula from uipath also

[RoboticApprentice]

I understand the logic but I don’t know exactly how to do it in UiPath.

I created a DataTable, then I selected the function “for each row” and specified my DataTable.
In the “for each row” activity I selected an If function, but what exactly do I have to write in it?

[ppr (Peter)]

@RoboticApprentice

giv a try on yourDataTableVar.AsEnumerable.Where(Function (row) row(“Newsletter”).toString.Trim.Equals(“yes”)).Sum(function (x) CInt(x(“Sales”).toString))