Spreadsheet: 819134d1677235606-formula-to-grouping-data-subtotal-each-depart-and-grand-total_3
Sheet: C

 |  |  |  |  |  |  |  |  |  |  |  |  | Without Colum G / Conditional Formatted
 | COMPANY |  | DEPT |  | NAME |  | Qty |  | Name | DEPT | COMPANY
 | XYZ. Inc |  | EXTERNAL RELATION |  | MARIYONO |  | 1
 | ABC. Inc |  | FINANCE & ACCOUNTING |  | NAWIL |  | 2 |  |  |  |  |  | ABC. Inc
 | XYZ. Inc |  | GENERAL SERVICES |  | WAHYUDIANTO |  | 3 |  | EXTERNAL RELATION | MARIYONO | XYZ. Inc | 1 | EXTERNAL RELATION | AHMAD | ABC. Inc | 19
 | XYZ. Inc |  | HUMAN RESOURCES |  | MUTTAQIN |  | 4 |  | EXTERNAL RELATION | NUR QAYIN | XYZ. Inc | 10 | Sub Total |  | 1 | 19
 | XYZ. Inc |  | MAINTENANCE & CONSTRUCTION |  | WILSON |  | 5 |  | Sub Total |  | 2 | 11 | FINANCE & ACCOUNTING | NAWIL | ABC. Inc | 2
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | FAHRIAL |  | 6 |  | FINANCE & ACCOUNTING | [NAME] | XYZ. Inc | 11 | FINANCE & ACCOUNTING | ADI PUTRANTO | ABC. Inc | 20
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | MOECHAMMAD |  | 7 |  | Sub Total |  | 1 | 11 | Sub Total |  | 2 | 22
 | XYZ. Inc |  | OPERATION |  | SELAMAT |  | 8 |  | GENERAL SERVICES | WAHYUDIANTO | XYZ. Inc | 3 | GENERAL SERVICES | ALFIAN | ABC. Inc | 21
 | XYZ. Inc |  | QSE |  | ARAFIK |  | 9 |  | GENERAL SERVICES | WAHYUDI | XYZ. Inc | 12 | Sub Total |  | 1 | 21
 | XYZ. Inc |  | EXTERNAL RELATION |  | NUR QAYIN |  | 10 |  | Sub Total |  | 2 | 15 | HUMAN RESOURCES | SUGENG | ABC. Inc | 22
 | XYZ. Inc |  | FINANCE & ACCOUNTING |  | [NAME] |  | 11 |  | HUMAN RESOURCES | MUTTAQIN | XYZ. Inc | 4 | Sub Total |  | 1 | 22
 | XYZ. Inc |  | GENERAL SERVICES |  | WAHYUDI |  | 12 |  | HUMAN RESOURCES | [NAME] | XYZ. Inc | 13 | MAINTENANCE & CONSTRUCTION | TRIYANTO | ABC. Inc | 23
 | XYZ. Inc |  | HUMAN RESOURCES |  | [NAME] |  | 13 |  | Sub Total |  | 2 | 17 | Sub Total |  | 1 | 23
 | XYZ. Inc |  | MAINTENANCE & CONSTRUCTION |  | ARIS |  | 14 |  | MAINTENANCE & CONSTRUCTION | WILSON | XYZ. Inc | 5 | MINE GEOLOGY & PLANNING | [NAME] | ABC. Inc | 16
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | MOHAMAD |  | 15 |  | MAINTENANCE & CONSTRUCTION | ARIS | XYZ. Inc | 14 | MINE GEOLOGY & PLANNING | IWAN | ABC. Inc | 24
 | ABC. Inc |  | MINE GEOLOGY & PLANNING |  | [NAME] |  | 16 |  | Sub Total |  | 2 | 19 | Sub Total |  | 2 | 40
 | ABC. Inc |  | OPERATION |  | LIN SLAMET |  | 17 |  | MINE GEOLOGY & PLANNING | FAHRIAL | XYZ. Inc | 6 | OPERATION | LIN SLAMET | ABC. Inc | 17
 | ABC. Inc |  | QSE |  | BAHAR |  | 18 |  | MINE GEOLOGY & PLANNING | MOECHAMMAD | XYZ. Inc | 7 | OPERATION | RISTANTO | ABC. Inc | 25
 | ABC. Inc |  | EXTERNAL RELATION |  | AHMAD |  | 19 |  | MINE GEOLOGY & PLANNING | MOHAMAD | XYZ. Inc | 15 | OPERATION | ABI HAIR | ABC. Inc | 26
 | ABC. Inc |  | FINANCE & ACCOUNTING |  | ADI PUTRANTO |  | 20 |  | Sub Total |  | 3 | 28 | Sub Total |  | 3 | 68
 | ABC. Inc |  | GENERAL SERVICES |  | ALFIAN |  | 21 |  | OPERATION | SELAMAT | XYZ. Inc | 8 | QSE | BAHAR | ABC. Inc | 18
 | ABC. Inc |  | HUMAN RESOURCES |  | SUGENG |  | 22 |  | Sub Total |  | 1 | 8 | QSE | ANDI YANTO | ABC. Inc | 27
 | ABC. Inc |  | MAINTENANCE & CONSTRUCTION |  | TRIYANTO |  | 23 |  | QSE | ARAFIK | XYZ. Inc | 9 | Sub Total |  | 2 | 45
 | ABC. Inc |  | MINE GEOLOGY & PLANNING |  | IWAN |  | 24 |  | Sub Total |  | 1 | 9 | Grand Total |  | 13 | 260
 | ABC. Inc |  | OPERATION |  | RISTANTO |  | 25 |  | Grand Total |  | 14 | 118 | Grand Total All |  | 27 | 378
 | ABC. Inc |  | OPERATION |  | ABI HAIR |  | 26
 | ABC. Inc |  | QSE |  | ANDI YANTO |  | 27