Help with SUMIFS formula with two columns as criteria.

Coen

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!

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

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