Is it possible to have a count based on another count?

Question

I have a formula that counts answers that do not meet certain criteria. Here is the formula: =COUNTA(K3:K325)-SUM(COUNTIF(K3:K325,"*" & {"Not Interested","Career Link","OVR","VBA","No Show","Vet Canceled"} & "*")) I have a second formula that counts the answer for Support Ed, during October: =COUNTIFS(Referrals!$H$3:H$325,"Support Ed",Referrals!$A$3:$A$325,"<"&'Month Source'!K7)(10/31/16), & one for the other 11 months, =COUNTIFS(Referrals!$H$3:$H$325,"Support Ed",Referrals!$A$3:$A$325,">="&'Month Source'!L6,Referrals!$A$3:$A$325,"<="&'Month Source'!L7)(11/30/16)I am trying to count the number of times that an answer does not match the above text, during a month.

Answer 1

To count everything in your range but certain values, you just need to modify the counting formula you already have. I gathered that your data is always comprised in rows 3 to 325 so wrote the formula accordingly. I also suggest that you create a list of the elements you want to count (or in this case not count) as it makes it easier to add or delete elements from a list than go in every formula you have:

=ROW(K325)-2-SUMPRODUCT(COUNTIF(K3:K325,"*" & Named_List & "*"))

I'm not sure how your data is arranged by month so I couldn't add that, but you seem to have figured out that part already. You can probably use what you already have for other formulas with this one.