Hi there,

What can I replace my countifs + countifs with? 
=COUNTIFS('Master Host List'!B:B,"Windows",'Master Host List'!AM:AM,"*DDMI*")+COUNTIFS('Master Host List'!B:B,"Windows",'Master Host List'!AM:AM,"*CA*")
I'm attempting to say - if Column AM contains the text like DDMI or like CA, then count all the Windows Servers in column B.

I've tired various combinations of If OR, then countifs, but I can't get the correct combination.

Thanks,
J