May 18 2022 06:05 PM
Hello,
I am trying to get the following formula to work and I don't know what else to do. If anyone can help it would be greatly appreciated.
=SUMIFS(CostQty,Customer,Recon!B149,zTaskID,Recon!A153,PayCode,Recon!B151)
May 18 2022 08:02 PM
@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?