Countifs/Sumifs with multiple criteria which reference another sheet

Bill Raymond

I'm trying to make a Metrics sheet to use on a dashboard. I would like to count all of the instances of each (text) heading which fall during this month, then a second column for last month.

I can't get the dates to work so I created helper columns with the month, year, and month+year combined (ex April 2025 would be 42025).

Here is one formula that works: (Count Column is just a column containing the number 1 because Countifs was not working with the same inputs)

SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Year Helper}, =2025)

Here is what I want to work, but is returning #INCORRECT ARGUMENT SET

SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Month/Year Helper}, =42025)

or

SUMIFS({Count Column}, {Defect Name}, [Defect Name]@row, {Year Helper}, =2025, {Month Helper}, =4)

I have checked my references, and they are correct and spelled correctly. Every time I try to add a 3rd range/criterion, I get error messages, even if they work individually. The helper columns are text columns containing formulas

EDIT As soon as I posted this, I went back to the sheet and all of the formulas are working. No idea what happened. I didn't change anything

kowal

100% Murphy Law :)

Glad your problem got resolved.