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.

• ✭✭✭✭✭✭
edited 05/14/24

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)

• ✭✭✭✭✭✭

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!