moderated Re: Excel Formula
Tanguy LOHEAC
Hi Steve, 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
like that =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 Tanguy
Le 26/06/2019 à 01:17, Steve &
Shannon Cook a écrit :
--
|
||
|