Why is my countifs formula not working

Options
mleesc
mleesc
edited 05/13/24 in Formulas and Functions

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)

Tags:

Best Answer

  • bisaacs
    bisaacs ✭✭✭✭✭
    Answer ✓
    Options

    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!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

Answers

  • bisaacs
    bisaacs ✭✭✭✭✭
    Options

    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?

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

  • mleesc
    Options

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

  • bisaacs
    bisaacs ✭✭✭✭✭
    Answer ✓
    Options

    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!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

  • mleesc
    Options

    @bisaacs Thanks that was the problem

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!