I have a column that has "yes" or "no" for certain criteria. I need to select the value a couple of columns of over for each of the cells that says "yes," then sum and divide that number by another number. I know how to do this using an entire column, but I would like to do this in one cell if possible.

Thanks in advance for the help!