Average across columns

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!

Hi,

You can use SUMIF formula. if your data

If your data like this..

. A B
1 11 Yes
2 22 No
3 33 yes

Then use below formula to get the sum. Then you can divide that result.

Please Login or Register  to view this content.