I want to sum total for all

[Sshasnk]

I want to sum the total by company name, So I have consolidated data of the different companies in a single sheet, Now I have to sum the total and by company name, I have to generate output but the total value should always be at the bottom.

Input:

Company name	amount	buy	purchase	Name
abc	145	15	145	Alex
abc	145	845	45	Jhon
abc	124	785	211	tim
abc	2354	48	484	rick
abc	145	58	145	Jhon
LMN	145	487	456	tim
LMN	745	845	214	rick
LMN	156	456	124	lane
EFG	1456	456	489	Rick
EFG	145	145	564	Mike
EFG	147	123	123	tim
EFG	156	145	489	lane

Output:

Company name	amount	buy	purchase	Name
abc	145	15	145	Alex
abc	145	845	45	Jhon
abc	124	785	211	tim
abc	2354	48	484	rick
abc	145	58	145	Jhon
Total	2913	1751	1030
LMN	145	487	456	tim
LMN	745	845	214	rick
LMN	156	456	124	lane
Total	1046	1788	794
EFG	1456	456	489	Rick
EFG	145	145	564	Mike
EFG	147	123	123	tim
EFG	156	145	489	lane
Total	448	869	1665

[DenisZ]

Please see attached batch macro workflow. Do mark as solved if it solves the issue

[ShankerV]

Hi @Sshasnk 

Please find one way to reach solution

Many thanks

Shanker V

[ShankerV]

Hi @Sshasnk 

Step 1: Input

Step 2: 

Step 3:

Stpe 4:

Step 5:

Expected output

[KrishnaChithrathil]

@Sshasnk 

What about this??