Countifs - Multiple options

[Welsh Mark3]

I am using the following formula (that works) - =COUNTIF(Masterdata!C:C,"New Customer")

Is there a way that I can include additional criteria? So for example, if I wanted to count if text contains New Customer or Old Customer?

Perhaps this is the best way to do this?
=COUNTIF(Masterdata!C:C,"New Customer")+COUNTIF(Masterdata!C:C,"Old Customer")

 

[Fluff]

What version of Excel are you using?

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’)

Try

=SUM(COUNTIFS(Masterdata!C:C,{"New Customer","Old Customer"}))