Sum rows in Excel and count in another Excel Sheet

Hello Friends,
I have this Excel File.
16797_031018_output del_04102018_ore_170105.xls (150.5 KB)
I should count all the rows with the same value of the column “Esito”,get the corresponding value of the column "Avere"


put the sum of the rows of each type of “Esito” in another sheet,with the corresponding value of the sum of the values of the column “Avere”, like this sheet

Can anyone help me please in sharing a xaml of example?
It’s very urgent for the client.
Thank you so much,
Camilla :slight_smile:

1 Like

@CamiCat Please find the attached workflow below.

count.xaml (16.2 KB)

1 Like

Use read range, Then you will be having data table,
Now write a linq select query
Select count(Column_Name) from (Table_Name) where Col like %‘ESito’%
you can you any functions such as sum, max, distinct and count in your select query.

1 Like

Thank you so much, @Manjuts90.
You gave me the correct solution to my problem.
It was so kind of you.
Best regards,
Camilla :slight_smile::blush::blush:

1 Like

@CamiCat Ur welcome bro.

1 Like