Why is my countifs formula not working

mleesc

This works

=COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1)

But this gives an incorrect argument error

=COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1), {Event Management Sheet Range 12}, 1)

bisaacs

Hey @mleesc,

In this instance, I think there's something wrong with the range of Range 12. So each range in the formula only covers 1 column each, but do they cover the same # of rows? If the Range 12 doesn't cover the same # of rows/columns, it would throw an incorrect argument. This works:

=COUNTIFS(Test:Test, 123, [Column7]:[Column7], 1)

But this would throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Column7]1:[Column7]25, 1)

This would also throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Test 2]:[Column7], 1)

Hope this helps!

bisaacs

Hey @mleesc,

What's the column type for the Range 12 you're looking at? Is it the same # of columns in the rest of the COUNTIFS formula?

mleesc

@bisaacs Range 12 is a Text/Number Column. Range 3 is a Text/Number Column, Range 7 is a data column

bisaacs

Hey @mleesc,

In this instance, I think there's something wrong with the range of Range 12. So each range in the formula only covers 1 column each, but do they cover the same # of rows? If the Range 12 doesn't cover the same # of rows/columns, it would throw an incorrect argument. This works:

=COUNTIFS(Test:Test, 123, [Column7]:[Column7], 1)

But this would throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Column7]1:[Column7]25, 1)

This would also throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Test 2]:[Column7], 1)

Hope this helps!

mleesc

@bisaacs Thanks that was the problem