Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?