Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 07 Dec 2020 19:28:23 +0100err 509 in sumifhttps://ask.libreoffice.org/en/question/163698/err-509-in-sumif/ I get Err 509 with the statement sumif(i2:i234;B2;G2:G234)
The column i contains numbers corresponding to the index in B2. Some are equal, some are not. The idea is that the sum extends over tose indices in column i that are equal to B2. What am I doing wrong?
Thanks, JosThu, 23 Aug 2018 22:03:11 +0200https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/Answer by Genesis for <p>I get Err 509 with the statement sumif(i2:i234;B2;G2:G234)
The column i contains numbers corresponding to the index in B2. Some are equal, some are not. The idea is that the sum extends over tose indices in column i that are equal to B2. What am I doing wrong?
Thanks, Jos</p>
https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?answer=281259#post-id-281259fixed =INDIRECT("'file:///c:/users/no/documents/curatorship/annual report " & A1 & "/debit expenses " & A1 & ".ods'#SHeet1.B45")
by mikekaganski on IRC
there was a backwards double quote somehow, only could see it with magnifier app
but External content disabled as i was working with a copy of the spread sheetMon, 07 Dec 2020 17:44:08 +0100https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?answer=281259#post-id-281259Comment by Ratslinger for <p>fixed =INDIRECT("'file:///c:/users/no/documents/curatorship/annual report " & A1 & "/debit expenses " & A1 & ".ods'#SHeet1.B45")
by mikekaganski on IRC</p>
<p>there was a backwards double quote somehow, only could see it with magnifier app
but External content disabled as i was working with a copy of the spread sheet</p>
https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?comment=281276#post-id-281276@Genesis,
Appears you posted this in the wrong location. Should it not be here -> [string subtitution on a external reference fails?](https://ask.libreoffice.org/en/question/281223/string-subtitution-on-a-external-reference-fails/)?
If so, please post there and delete this post.Mon, 07 Dec 2020 19:28:23 +0100https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?comment=281276#post-id-281276Answer by erAck for <p>I get Err 509 with the statement sumif(i2:i234;B2;G2:G234)
The column i contains numbers corresponding to the index in B2. Some are equal, some are not. The idea is that the sum extends over tose indices in column i that are equal to B2. What am I doing wrong?
Thanks, Jos</p>
https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?answer=163756#post-id-163756Err:509 means *operator expected*, make sure you don't have a typo in your formula expression. If in doubt copy&paste it to here exactly as it is without altering. If indeed you entered =sumif(... and it remains lower case (if recognized it would be shown upper case) then you're probably using an UI language that has localized function names (i.e. Dutch), so that could be SOM.ALS instead.Fri, 24 Aug 2018 14:03:38 +0200https://ask.libreoffice.org/en/question/163698/err-509-in-sumif/?answer=163756#post-id-163756