COUNTIFS AND Formula Assistance

Hello Community!

I could use your assistance with a sheet summary formula. I'm looking to count the total number of times an [Account Manager] has a [Field Ride End Date] within 180 days. Right now, I have the formula as =COUNTIFS([Account Manager]:[Account Manager]), "NAME"), AND([180 Days]:[180 Days], <180))

I added the helper columns for assistance but I keep drawing #unparseable. Thanks in advance for your help.

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/14/24

    @chris.walton

    Try removing the And Function. With Countifs() the Syntax is (Range1, Criteria1, Range2,Criteria2…..) so on.

    =COUNTIFS([Account Manager]:[Account Manager],"NAME",[180 Days]:[180 Days],<180)

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Still coming up #unparseable. Even switched the order of sequence. Appreciate the suggestion, Mark!

    =COUNTIFS([Account Manager]:[Account Manager], "Peter Spyra"),[180 Days]:[180 Days], <180)

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭

    @chris.walton

    I am sorry it took so long. you may have figured it out on your own by this point. but you have an extra ) in your formula try:

    =COUNTIFS([Account Manager]:[Account Manager], "Peter Spyra", [180 Days]:[180 Days], <180)

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!