I would like to return for example total value of COMP from Manufactured Status Cell in Cars Information Sheet to Summary Sheet, The rest status is the same.
Output Should Be as Following:
Total Cars Complete ( COMP): 3
Total Cars Pending (APPR+INPRG+WAPPR): 12
Total Canceled Cars(CAN): 3
Attached workbook for your reference.