@Meg79 With further context, it's difficult to diagnose the issue. your formula is set to SUM from a range called CostQty. Then it checks three named ranges, Customer, zTaskID and PayCode, for a match with three cells from the Recon sheet. B149, A153 and B151 respectively. It returns the sum if all three criteria are met.
What does your formula return? An error? If so, which one? Zero?