SUMIF / SUMIFS Calculation

Copper 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")