Help with SUMIFS formula with two columns as criteria.

Options
✭✭✭✭

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:

=SUM(Collected:Collected)

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

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

Any guidance is greatly appreciated.

tyty!

Tags:

• ✭✭✭✭✭
Options

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!

• ✭✭✭✭
Options

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!