Hi all
I am trying to work out a formula that looks at 10 different cells that have a yes or no in it and I want to do a percentage of how many are yes.
So if 10 no then it'd be 0% if 1 no it'd be 90%.
I can't seem to work a formula out as all formulas I can think of only work with a cell list not cell here cell there ie. I'd have a yes in e12 then a yes or no in l13 then yes or no in t5 n I don't want it looking at cells in between these ones.
Hope this makes sense
Thanks
I am trying to work out a formula that looks at 10 different cells that have a yes or no in it and I want to do a percentage of how many are yes.
So if 10 no then it'd be 0% if 1 no it'd be 90%.
I can't seem to work a formula out as all formulas I can think of only work with a cell list not cell here cell there ie. I'd have a yes in e12 then a yes or no in l13 then yes or no in t5 n I don't want it looking at cells in between these ones.
Hope this makes sense
Thanks