Please can you guide me as I'm not sure what I do wrong with this formula
=SUMIFS(INDEX('2018 volume'!$A$1:$N$70,0,MATCH($E$1,'2018 volume'!$C$1:$N$1,0)+COLUMNS($C:$C)-1),'2018 volume'!$A$1:$A$70,$A3)
workbook attached
Please can you guide me as I'm not sure what I do wrong with this formula
=SUMIFS(INDEX('2018 volume'!$A$1:$N$70,0,MATCH($E$1,'2018 volume'!$C$1:$N$1,0)+COLUMNS($C:$C)-1),'2018 volume'!$A$1:$A$70,$A3)
workbook attached
I suppose that COLUMNS($C:$C) is not right.
Try COLUMNS($C:C)
Please try at D2
=SUMIFS(INDEX('2018 volume'!$A$1:$N$70,0,MATCH(D$1,'2018 volume'!$A$1:$N$1,0)),'2018 volume'!$A$1:$A$70,SUBSTITUTE($A2,", CSA",""))
Last edited by Bo_Ry; 02-20-2019 at 04:38 AM.
Hi
the answer I'm looking for in D2 & D3 should be as follows
Plant Terminal Product January-2018
JBS SEAFARERS CIRCLE, TRM, CSA JBS Fuel Oil 6 803 286
JBS SEAFARERS CIRCLE, TRM, CSA JBS Marine Gas Oil 6 502 749
I tried the above
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks