CountIFs Range in same colomn

MarcelleM

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?

J Tech

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)