Excel: Counting certain text in a selection


Hi all, I've got this code, & it's not bringing back the results I'm after. =(IF(OR(COUNTIF(K7:M28,"No - Major")>0,1,COUNTIF(K7:M28,"No - Minor")>2,2),"")) K7-M28 are the cells (columns K, L & M are merged cells on each row). Basically if any of these cells have a "No - Major" in them then the result in K29 should be 1, but if any have "No - Minor" three times or more than this should result in a 2. Hope you can help! Thanks.


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of August 03, 2015.


For more resources for Microsoft Excel