Sum the values of a column when it meets a condition

I have an excel with a surface column (number) and another contract column. I need that when a record has the same contract as the previous one, it adds the two surfaces

Hi @Marisa_Ontiveros1

Can u share the screenshot of the input and output u need in final?

The input table is this:Data.xlsx (10.1 KB)
in the output table , I need one column for surfaces and other column for contratc. I need when the contract is the same, sum the surfaces

@Marisa_Ontiveros1
we can do it with a groupby and summing up. Getting an introduction to it have a look here:

1 Like

Thank you very much

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