Help with SUMIFS formula with two columns as criteria.

Good morning, Evening and afternoon.

I am struggling with a SUMIFS formula that is using criteria from two columns.

I'm not sure if this is affecting the formula or not: The column I am trying to SUM is:

Collected: =IFERROR(VLOOKUP([Order Num]@row, {Dell World SKU Import Results Range 1}, 2, false), 0)

My current SUMIFS formula is:

=SUMIFS(Collected:Collected, [Applied to FY]:[Applied to FY], "2024", Quarter:Quarter, "Q2")

This yields a result of $0.00

I am able to:


=SUMIF(Quarter:Quarter, "Q2", Collected:Collected)

Running the SUMIFS formula with just one criteria also yields a $0.00

Any guidance is greatly appreciated.




  • Toufong Vang
    Toufong Vang ✭✭✭✭✭

    Hi, @Coen . Check if the values in [Applied to FY]:[Applied to FY] are strings/text or numbers. Use =COUNTIF([Applied to FY]:[Applied to FY], "2024"). If it returns "0" then the values are strings and you'll need to modify the criterion to VALUE(@cell) = 2024 .

    =SUMIFS(Collected:Collected, [Applied to FY]:[Applied to FY], VALUE(@cell) = 2024, Quarter:Quarter, "Q2")

    Hope this helps!

  • Coen
    Coen ✭✭✭✭

    Thank you, I will try this today! Many thanks!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!