Sep 04 2021 01:54 AM
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.
Sep 04 2021 02:08 AM
That could be like
=SUMIFS( <Split OB USD total column>,
<Split SKU column>, SKU value,
<Split Incoter colum>, "FOB" )
Sep 04 2021 02:13 AM
=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")