SUMIFS

%3CLINGO-SUB%20id%3D%22lingo-sub-3397052%22%20slang%3D%22en-US%22%3ESUMIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3397052%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20the%20following%20formula%20to%20work%20and%20I%20don't%20know%20what%20else%20to%20do.%26nbsp%3B%20If%20anyone%20can%20help%20it%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMIFS(CostQty%2CCustomer%2CRecon!B149%2CzTaskID%2CRecon!A153%2CPayCode%2CRecon!B151)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3397052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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)

1 Reply

@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, CustomerzTaskID 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?