Countifs + Countifs - replacement?

**JulieQ** · 03-05-2015, 02:55 PM

Hi there,

What can I replace my countifs + countifs with?

Please Login or Register  to view this content.

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

**JulieQ** · 03-05-2015, 03:00 PM

SOLVED MYSELF

=SUM(COUNTIFS('Master Host List'!B:B,"Windows",'Master Host List'!AM:AM,{"*DDMI*","*CA*"}))

**Sam Capricci** · 03-05-2015, 03:02 PM

usually you use a countifs like this... COUNTIFS(criteria Range 1, criteria 1, criteria range 2, criteria 2) so you should be able to combine the two into one countifs. You can use the double countifs if you are going to count things like that from different columns, so if DDMI was in one column and CA in another one.

EDIT: was still typing when you discovered one answer.