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 |