View Single Post
 
Old 04-22-2019, 11:07 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Either you need some additional conditions to compare with, or you did a mistake in 2nd data row on sheet Base File.

Otherwise the formula in attachment works.

Edit:
To make tables expanding automatically, define both tables as Tables (From menu Insert>Table), and edit formula to use Table syntax, like
Code:
=SUMIFS(tBAF[BAF];tBAF[POL];[@POL];tBAF[POD];[@POD];tBAF[S/L];[@S/L];tBAF[Container];[@Container];tBAF[From];"<=" & [@To];tBAF[To];">=" & [@From])
Edit::
Change parameter delimiters to commas, in case you use e.g. US settings!
Formula assumes, that it is entered into field of Table (e.g. tBase) on sheet BaseFile. When the formula is outside of tBase (but on same row it refers to for tBase values), you have to replace all [@FieldName] in formula with tBase[@FieldName].
I ma not sure how using "/" in field name of Table affects formulas - maybe there is additional pair of square brackets needed.
Attached Files
File Type: xlsx BAF.xlsx (14.1 KB, 7 views)
Reply With Quote