CountIFs Range in same colomn

MarcelleM
MarcelleM ✭
in Formulas and Functions

I am trying to do a count of number of contract that will be expiring between 30 - 60 days

I tried these and various formulae but still nothing works:

=COUNTIFS([Days till Contract Expiry]:[Days till Contract Expiry], “>=”&30, [Days till Contract Expiry]:[Days till Contract Expiry], “<=”&60)

and

=COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >30, <60)

Can someone assist?

· Share on FacebookShare on Twitter

Best Answer

  • J Tech
    J Tech ✭✭✭✭✭
    edited 03/14/22 Answer ✓

    Hi,

    I presume you are entering this into a sheet summary field, you can try the below formula:

    =COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >29) - COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >60)

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
    · Share on FacebookShare on Twitter

Answers

  • J Tech
    J Tech ✭✭✭✭✭
    edited 03/14/22 Answer ✓

    Hi,

    I presume you are entering this into a sheet summary field, you can try the below formula:

    =COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >29) - COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >60)

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
    · Share on FacebookShare on Twitter
  • MarcelleM
    MarcelleM ✭

    Yes it is in the summary field. Thank you so much, that worked.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!