Sumproduct-select a range

Hi guys, I'm trying to select a range of cells to test a text value using if condition but for soem reason it is not working! for example if i use :
=IF (OR(a1="mike",b10="mike",c4="mike"),1,"") this will work fine but is there any other way to write this formula so i do not have to write every single cell and just chose them.

thanx in advance.