Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 20 Feb 2016 04:17:09 +0100Does calc fail on some named reference formulas?https://ask.libreoffice.org/en/question/64763/does-calc-fail-on-some-named-reference-formulas/ I have a named range ORDERS in a3:k100
Row 3 contains labels such as JOB, QTY, COST, etc.
A formula SUMIF(JOB,JOB,QTY) should take the current row's JOB value and sum QTY for all rows where the JOB culumn holds a value equal to the current row's JOB value.
It used to work but now does not.
Suggestions?
Sat, 20 Feb 2016 04:17:09 +0100https://ask.libreoffice.org/en/question/64763/does-calc-fail-on-some-named-reference-formulas/