I have a spreadsheet that was created in MS Excel that has a function =SUMIF(Table1[R],"=r",Table1[deposit, credit (+)]). This function is giving an error 507. I suspect this is a syntax issue regarding range addressing and the use of headers. Any clues? (Version: 6.4.5.2 (x64)) Thanks
Most likely (if your function parameter separator is comma) bug tdf#131424 fixed for 6.4.6, until then remove the , comma separator from the field name.
Update 2020-07-23T14:16+02:00
To clarify, you need to remove the comma from both the column name/label and in the formula expression where the column name is used so that it reads
=SUMIF(Table1[R],"=r",Table1[deposit credit (+)])Please see the formula in my original question. There are no commas except as separators between the range and criteria as per the examples. Removing the comma from the column name results in an err:509.
I’m not familiar with the Excel’s table reference syntax, but it seems that your header still contains the “unusual” characters - I assume that the header is named deposit, credit (+), so includes a comma, parentheses and a plus, right? which are all handled by the fix mentioned by @erAck, and should be temporarily removed until the fixed version is available.
See this example.xlsx, which works fine with version 7.0.0.2.
(Just tested that removing parentheses and plus was not needed, and it was only the comma that broke the example in previous versions.)