SUMIF / SUMIFS Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2719403%22%20slang%3D%22en-US%22%3ESUMIF%20%2F%20SUMIFS%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719403%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20calculate%20a%20total%20sales%20figure%20of%20a%20product%20(CPNY-22-389)%20on%20a%20sheet%20%22Images%22%20-%20but%20I%20want%20only%20FOB%20incoterm%20sales%2C%20from%20sheet%20%22Split%22.%20As%20in%202nd%20screenshot%2C%20the%20product%20is%20also%20sold%20under%20inocterm%20DDP%20but%20I%20only%20want%20a%20total%20sales%20figure%20of%20the%20FOB%20incoterm.%20Please%20can%20someone%20help%20advise%20what%20function%20to%20use%3F%20I%20am%20trying%20SUMIF%20%2F%20SUMIFs%20but%20cannot%20seem%20to%20calculate.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2719403%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719435%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20%2F%20SUMIFS%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146555%22%20target%3D%22_blank%22%3E%40JOESANDERS95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUMIFS(%20%3CSPLIT%20ob%3D%22%22%20usd%3D%22%22%20total%3D%22%22%20column%3D%22%22%3E%2C%0A%20%20%20%3CSPLIT%20sku%3D%22%22%20column%3D%22%22%3E%2C%20SKU%20value%2C%0A%20%20%20%3CSPLIT%20incoter%3D%22%22%20colum%3D%22%22%3E%2C%20%22FOB%22%20)%3C%2FSPLIT%3E%3C%2FSPLIT%3E%3C%2FSPLIT%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I am trying to calculate a total sales figure of a product (CPNY-22-389) on a sheet "Images" - but I want only FOB incoterm sales, from sheet "Split". As in 2nd screenshot, the product is also sold under inocterm DDP but I only want a total sales figure of the FOB incoterm. Please can someone help advise what function to use? I am trying SUMIF / SUMIFs but cannot seem to calculate. 

2 Replies

@JOESANDERS95 

That could be like

=SUMIFS( <Split OB USD total column>,
   <Split SKU column>, SKU value,
   <Split Incoter colum>, "FOB" )

@JOESANDERS95 

 

=SUMIFS(Split!TotalColumn,Split!SKUColumn=SKU,Split!IncotermColumn =INCOTER)

=SUMIFS(Split!E2:E...,Split!A2:A...="CPNY-22-389",Split!B2:B...="FOB")

 

=SUMIFS(Split!E2:E...;Split!A2:A...=B4,Split!B2:B...="FOB")