New Contributor

Im trying to do this if c4:c11 is b and d4:ah4-11 is c then af 27= 1 in excel but the only thing I can find is a countifs and as I don't have equal cells the equation just gives me a #value. I am new to this and have tried searching online but to no avail .Capture3.PNG