Hi there,
What can I replace my countifs + countifs with?
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.=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've tired various combinations of If OR, then countifs, but I can't get the correct combination.
Thanks,
J
Bookmarks