Sample_data.xlsx (15.6 KB)
Basically what I’m after is the equivalent of this:
That is, sum all amounts belonging to the same ID, given that they are postive numbers and don’t have the “Text B” text in column B.
I can do this in the excel sheet I am importing from, but it’s very slow on large number of rows, so I’m looking for a better way of doing it. Can this be done via an assign operation and some sort of magic?