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