When the SearchCriteria of DSUM is A70:D71,i.e., =DSUM(A1:G68,“Amount”,A70:D71), DSUM works correctly. When SearchCriteria is extended to the full width of the database, i.e., A70:G71, DSUM fails with Err:504. Even extending to the next column causes the error. I have deleted everything from the empty fields of SearchCriteria to make sure nothing invisible is causing the problem and I have verified the format of each column matches between the SearchCriteria and Database.
Operating System: Windows 7
LibreOffice Version: 4.4.1.2
Syntax:
DSUM(Database; DatabaseField; SearchCriteria)