Formula with date which need to match & got error message

ArviLaanemets · #2 04-22-2019, 11:07 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Error Message Run time Error 4605	baes10	Word VBA	1	08-30-2018 02:37 PM
Reserved error(-1517); there is no message for this error	ktest	Office	1	02-12-2016 08:08 PM
Automation error Unknown error" message once they open the Excel file	hlina	Excel	1	10-08-2013 09:14 PM
Macro date and match valor	cg1980	Excel Programming	0	04-12-2011 09:38 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM