Here is the formula I created >>
=COUNTIF(C31:C32,"d")+COUNTIF(C31:C32,"d/s")+COUNTIF(C12:C19,"d/s") +COUNTIF(C12:C19,"d")
Is there a way to combine COUNTIF(C31:C32,"d") AND COUNTIF(C31:C32,"d/s")
I would like to shorten this formula if possible.
I'd tired =COUNTIF(C12:C19,"d/s","d")+COUNTIF(C31:C32,"d/s","d") but it wouldn't let me.
Any help would be great.
Bookmarks