SUMIFS with vLookup or Indexing?

%3CLINGO-SUB%20id%3D%22lingo-sub-2620107%22%20slang%3D%22en-US%22%3ESUMIFS%20with%20vLookup%20or%20Indexing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620107%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20of%20data%2C%20about%207k%20lines%20that%20I%20need%20to%20cost%20allocate.%20I've%20added%20a%20small%20portion%20below%20as%20an%20example.%20What%20I%20would%20like%20to%20display%20with%20a%20formula%20is%20the%20total%20for%20each%20cost%20center%20by%20document%20number.%26nbsp%3B%26nbsp%3BIn%20other%20words%2C%20cost%20center%20%222539%22%20below%20would%20display%20Doc%23%2040859728%20as%20%245.00%20and%20Doc%23%2040885398%20as%20%245.65.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20also%20like%20to%20further%20allocate%20the%20total%20for%20Doc%23%2040874160.%20Although%20one%20entry%2C%20for%20%243.81%2C%20solely%20belongs%20to%20cost%20center%20%222616%22%2C%20an%20additional%20entry%20for%20that%20Doc%23%20belongs%20to%20more%20than%20one%20cost%20center%2C%20%222616%22%20and%20%223571%22.%20How%20can%20I%20display%20that%20split%3F%20I%20would%20like%20Doc%23%2040874160%20to%20return%20two%20results%3A%20a%20total%20of%20%244.02%20for%20cost%20center%20%222616%22%20and%20only%20%240.21%20for%20%223571%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20pivot%20table%2C%20but%20I'm%20not%20as%20experienced%20with%20those%20and%20not%20sure%20if%20that%20would%20even%20help.%26nbsp%3B%20I'm%20ok%20with%20formulas%2C%20but%20not%20so%20well%20with%20nested%20functions%20so%20I've%20not%20been%20able%20to%20figure%20out%20the%20best%20way%20to%20display%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20you%20can%20provide!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22500%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2279%22%3EDocument%3C%2FTD%3E%3CTD%20width%3D%22106%22%3E%26nbsp%3BAmount%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22142%22%3ECost%20Center%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40886025%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.53%3C%2FTD%3E%3CTD%3E2529%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40861530%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%207.70%3C%2FTD%3E%3CTD%3E3563%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40881086%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%207.70%3C%2FTD%3E%3CTD%3E3561%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40861530%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%209.90%3C%2FTD%3E%3CTD%3E3562%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40881087%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%207.70%3C%2FTD%3E%3CTD%3E3564%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E40859728%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.00%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E2539%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E40885398%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202.30%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E2539%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E40885398%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E2539%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E40885398%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203.35%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23008000%22%3E%3CSTRONG%3E2539%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40862560%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201.31%3C%2FTD%3E%3CTD%3E2648%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40862560%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201.62%3C%2FTD%3E%3CTD%3E2648%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40862560%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201.24%3C%2FTD%3E%3CTD%3E2648%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E40862560%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201.31%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E2616%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E40874160%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203.81%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E2616%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E40874160%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%200.42%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E2616%2F3571%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40857867%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.40%3C%2FTD%3E%3CTD%3E2551%2F3560%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40857867%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202.44%3C%2FTD%3E%3CTD%3E2551%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40857867%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%209.56%3C%2FTD%3E%3CTD%3E2551%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40881088%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.00%3C%2FTD%3E%3CTD%3E3560%2F3566%2F3575%2F3579%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40885934%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E2631%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40885934%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E2631%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40863091%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.30%3C%2FTD%3E%3CTD%3E2615%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40863091%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.46%3C%2FTD%3E%3CTD%3E2615%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40863091%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.83%3C%2FTD%3E%3CTD%3E2615%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2097.88%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2620107%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2620763%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIFS%20with%20vLookup%20or%20Indexing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849177%22%20target%3D%22_blank%22%3E%40RGarrett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYu%20may%20aggregate%20that%20with%20PivotTable.%20Cost%20Centres%20to%20split%20manually%20or%20with%20Power%20Query%2C%20when%20the%20result%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20280px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301101i597A50299DAAA39F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2620849%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIFS%20with%20vLookup%20or%20Indexing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620849%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFollow%20up%20-%20in%20the%20above%20view%2C%20cost%20center%203571%20shows%20a%20full%20%240.42%20but%20I%20want%20to%20split%20it%20in%20half%20(between%203571%20and%202616).%26nbsp%3B%20How%20do%20I%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625582%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIFS%20with%20vLookup%20or%20Indexing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849177%22%20target%3D%22_blank%22%3E%40RGarrett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20forgot%20to%20split.%20That's%20like%20in%20attached%20file.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20255px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301651i5750137C65473F60%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a spreadsheet of data, about 7k lines that I need to cost allocate. I've added a small portion below as an example. What I would like to display with a formula is the total for each cost center by document number.  In other words, cost center "2539" below would display Doc# 40859728 as $5.00 and Doc# 40885398 as $5.65.

 

I would also like to further allocate the total for Doc# 40874160. Although one entry, for $3.81, solely belongs to cost center "2616", an additional entry for that Doc# belongs to more than one cost center, "2616" and "3571". How can I display that split? I would like Doc# 40874160 to return two results: a total of $4.02 for cost center "2616" and only $0.21 for "3571". 

 

I have tried a pivot table, but I'm not as experienced with those and not sure if that would even help.  I'm ok with formulas, but not so well with nested functions so I've not been able to figure out the best way to display this.

 

Thanks for any help you can provide!!

 

Document Amount Cost Center
40886025 $                   5.532529
40861530 $                   7.703563
40881086 $                   7.703561
40861530 $                   9.903562
40881087 $                   7.703564
40859728 $                   5.002539
40885398 $                   2.302539
40885398 $                       -  2539
40885398 $                   3.352539
40862560 $                   1.312648
40862560 $                   1.622648
40862560 $                   1.242648
40862560 $                   1.312616
40874160 $                   3.812616
40874160 $                   0.422616/3571
40857867 $                   5.402551/3560
40857867 $                   2.442551
40857867 $                   9.562551
40881088 $                   5.003560/3566/3575/3579
40885934 $                       -  2631
40885934 $                       -  2631
40863091 $                   5.302615
40863091 $                   5.462615
40863091 $                   5.832615
  $                 97.88 
3 Replies

@RGarrett 

Yu may aggregate that with PivotTable. Cost Centres to split manually or with Power Query, when the result is

image.png

@Sergei Baklan 

 

Follow up - in the above view, cost center 3571 shows a full $0.42 but I want to split it in half (between 3571 and 2616).  How do I achieve this?

@RGarrett 

Yes, forgot to split. That's like in attached file.

image.png