COUNTIF Formula String

[Radiatedjay2]

The formula string below currently counts the number of supervisors scheduled to work based on specific entries in three cells. Certain entries add to the count and certain entries subtract from the count.

=COUNTIF(KI4:KI6,"*N*")+COUNTIF(KI4:KI6,"PHY")+COUNTIF(KI4:KI6,"TRD")+COUNTIF(KI4:KI6,"MT")+COUNTIF(KI4:KI6,"*D*")-COUNTIF(KI4:KI6,"DC")-COUNTIF(KI4:KI6,"XD")-COUNTIF(KI4:KI6,"XN")

What I need it to do is subtract 1 from the total if the total is => 3. How would I modify this formula to accomplish that.

 

[Fluff]

Using Microsoft 365 for Enterprise

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)