Forum Discussion

Meg79's avatar
Meg79
Copper Contributor
May 19, 2022

SUMIFS

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)

Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 19, 2022

    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?

     

Resources