combine two formulas?

[NAPCOSARA]

I am trying to combine two formulas in excel, one to determine if a vendor is one of two options (the vendor number starts with M or not) and the other formula is to count the number of cells that are not blank. I basically need to count if a cell has data and then separate this into one of two vendor categories.

So far my formula to determine the vendor is =COUNTIF(RESPONSES!A2:A457, "*M*") or =COUNTIF(RESPONSES!A3:A458,"<>*M*")
and my formula to count data is =COUNTIF(RESPONSES!C2:C457, "<>")

Is there a way to combine the two formulas to make it determine the vendor category and then take it a step further to count the number of cells with data?

 

[Sufiyan97]

Try

=COUNTIFS(RESPONSES!A2:A457, "*M*",RESPONSES!C2:C457, "<>")