I have tried to get this done, but for some reason, my CountIfs will not work with OR criteria in the formula. The first 2 will count them fine but line 3, which I thought I had the correct code, doesn't!
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,"=*SEC*")=1,"YES","NO") - WORKS
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,"=*MIN*")=1,"YES","NO") - WORKS
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,{"=*SEC*","=*MIN*"})=1,"YES","NO") - FAILS, will not find either text when i use this.
Any help is greatly appreciated!
Mike
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,"=*SEC*")=1,"YES","NO") - WORKS
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,"=*MIN*")=1,"YES","NO") - WORKS
=IF(COUNTIFS('MERAKI CSV DATA'!A:A,A208,'MERAKI CSV DATA'!D:D,"MX6*",'MERAKI CSV DATA'!O:O,{"=*SEC*","=*MIN*"})=1,"YES","NO") - FAILS, will not find either text when i use this.
Any help is greatly appreciated!
Mike