moderated Re: Excel Formula
Sorry, i'm French, then I don't know exact function names in English. But i'll try to guide to the right path:
To get the number of "yes" from column B the formula is something
=nb.if(b2:b10;"yes") where b2:b10 is the range of rows you want to sum and "yes" is what you want to sum.
Then, to get the total number of tasks that are in column A this is:
=sub.total(3;a:a)-1 : here i'm not sure about the name but you may find it from the Math category.
Then fi you want a percentage this is first divided by second as follows:
=nb.if(b2:b10;"yes") / (sub.total(3;a:a)-1)
Hope that helps anyway
Le 26/06/2019 à 01:17, Steve & Shannon Cook a écrit :