28creation
Board Regular
- Joined
- Oct 13, 2014
- Messages
- 124
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.
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.