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:
=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!
Answers

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 toVALUE(@cell) = 2024
.=SUMIFS(Collected:Collected, [Applied to FY]:[Applied to FY], VALUE(@cell) = 2024, Quarter:Quarter, "Q2")
Hope this helps!

Thank you, I will try this today! Many thanks!!
Help Article Resources
Categories
Check out the Formula Handbook template!