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

 |  |  |  |  |  |  |  |  |  |  |  | Without Colum G / Conditional Formatted
 | COMPANY |  | DEPT |  | NAME | Code |  |  | Name | DEPT | COMPANY
 | XYZ. Inc |  | EXTERNAL RELATION |  | MARIYONO | EXR
 | ABC. Inc |  | FINANCE & ACCOUNTING |  | NAWIL | GAC |  |  |  |  |  | ABC. Inc
 | XYZ. Inc |  | GENERAL SERVICES |  | WAHYUDIANTO | GA |  |  | EXTERNAL RELATION | MARIYONO | XYZ. Inc | EXTERNAL RELATION | AHMAD | ABC. Inc
 | XYZ. Inc |  | HUMAN RESOURCES |  | MUTTAQIN | HRD |  |  | EXTERNAL RELATION | NUR QAYIN | XYZ. Inc | Sub Total |  | 1
 | XYZ. Inc |  | MAINTENANCE & CONSTRUCTION |  | WILSON | MEM |  |  | Sub Total |  | 2 | FINANCE & ACCOUNTING | NAWIL | ABC. Inc
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | FAHRIAL | MPL |  |  | FINANCE & ACCOUNTING | [NAME] | XYZ. Inc | FINANCE & ACCOUNTING | ADI PUTRANTO | ABC. Inc
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | MOECHAMMAD | MPL |  |  | Sub Total |  | 1 | Sub Total |  | 2
 | XYZ. Inc |  | OPERATION |  | SELAMAT | ODS |  |  | GENERAL SERVICES | WAHYUDIANTO | XYZ. Inc | GENERAL SERVICES | ALFIAN | ABC. Inc
 | XYZ. Inc |  | QSE |  | ARAFIK | ENV |  |  | GENERAL SERVICES | WAHYUDI | XYZ. Inc | Sub Total |  | 1
 | XYZ. Inc |  | EXTERNAL RELATION |  | NUR QAYIN | EXR |  |  | Sub Total |  | 2 | HUMAN RESOURCES | SUGENG | ABC. Inc
 | XYZ. Inc |  | FINANCE & ACCOUNTING |  | [NAME] | GAC |  |  | HUMAN RESOURCES | MUTTAQIN | XYZ. Inc | Sub Total |  | 1
 | XYZ. Inc |  | GENERAL SERVICES |  | WAHYUDI | GA |  |  | HUMAN RESOURCES | [NAME] | XYZ. Inc | MAINTENANCE & CONSTRUCTION | TRIYANTO | ABC. Inc
 | XYZ. Inc |  | HUMAN RESOURCES |  | [NAME] | HRD |  |  | Sub Total |  | 2 | Sub Total |  | 1
 | XYZ. Inc |  | MAINTENANCE & CONSTRUCTION |  | ARIS | MEM |  |  | MAINTENANCE & CONSTRUCTION | WILSON | XYZ. Inc | MINE GEOLOGY & PLANNING | [NAME] | ABC. Inc
 | XYZ. Inc |  | MINE GEOLOGY & PLANNING |  | MOHAMAD | MPL |  |  | MAINTENANCE & CONSTRUCTION | ARIS | XYZ. Inc | MINE GEOLOGY & PLANNING | IWAN | ABC. Inc
 | ABC. Inc |  | MINE GEOLOGY & PLANNING |  | [NAME] | MPL |  |  | Sub Total |  | 2 | Sub Total |  | 2
 | ABC. Inc |  | OPERATION |  | LIN SLAMET | ODS |  |  | MINE GEOLOGY & PLANNING | FAHRIAL | XYZ. Inc | OPERATION | LIN SLAMET | ABC. Inc
 | ABC. Inc |  | QSE |  | BAHAR | ENV |  |  | MINE GEOLOGY & PLANNING | MOECHAMMAD | XYZ. Inc | OPERATION | RISTANTO | ABC. Inc
 | ABC. Inc |  | EXTERNAL RELATION |  | AHMAD | EXR |  |  | MINE GEOLOGY & PLANNING | MOHAMAD | XYZ. Inc | OPERATION | ABI HAIR | ABC. Inc
 | ABC. Inc |  | FINANCE & ACCOUNTING |  | ADI PUTRANTO | GAC |  |  | Sub Total |  | 3 | Sub Total |  | 3
 | ABC. Inc |  | GENERAL SERVICES |  | ALFIAN | GA |  |  | OPERATION | SELAMAT | XYZ. Inc | QSE | BAHAR | ABC. Inc
 | ABC. Inc |  | HUMAN RESOURCES |  | SUGENG | HRD |  |  | Sub Total |  | 1 | QSE | ANDI YANTO | ABC. Inc
 | ABC. Inc |  | MAINTENANCE & CONSTRUCTION |  | TRIYANTO | MEM |  |  | QSE | ARAFIK | XYZ. Inc | Sub Total |  | 2
 | ABC. Inc |  | MINE GEOLOGY & PLANNING |  | IWAN | MPL |  |  | Sub Total |  | 1 | Grand Total |  | 13
 | ABC. Inc |  | OPERATION |  | RISTANTO | ODS |  |  | Grand Total |  | 14
 | ABC. Inc |  | OPERATION |  | ABI HAIR | ODS
 | ABC. Inc |  | QSE |  | ANDI YANTO | ENV