Datatable - Sum multiple row/column based on the fixed header

[Pratik_Wavhal]

Hi @shubham.nagar

Have a look to the below thread :-

How do I find the amount?

Hi @Perawat So here is the workflow for the same :- MainPratik.xaml (11.7 KB) test.xlsx (9.6 KB) Output :- [image] I have used the Linq as below in assign activity :- This will give the count for each data for Status A :- (From d In readExcelFromSheet1.asenumerable Where d(1).ToString.Equals(row("Data").ToString.Trim) And d(2).ToString.Equals("a")).count This will give the count for each data for Status C :- (From d In readExcelFromSheet1.asenumerable Where d(1).ToString.Equals(row("Da…

Might this will give you some starter help

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal