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?