Does calc fail on some named reference formulas?

asked 2016-02-20 04:17:09 +0200

gordon071 gravatar image

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?

edit retag flag offensive close merge delete