Conditional Formulae & Percentages

I have a spreadsheet that tracks assays and where people are with their trainings and their abilities to perform the assays. I would like formulae and conditional formulas to give a visual where people are. See attached workbook. If the cell is blackened (filled with the colour black) then that cell isn't taken into account when determining the number of columns that have a value (id east, not blank) to count against those not filled (and not blackened) to divide by one hundred (100) and return a percentage. The percentages of each assay with respect to east position type will average and display in the OVERVIEW tab. Is this a doable thing? I'm thinking something along the lines of =PERCENT(IF(ISBLANK(COUNTA())))). I could be way off and out in left field. Am I too ambitious that this would need a macro (for the blackened cells to skip)?

I put "n/a" in each of the blacked-out cells (without the quotes). This is only visible in the formula bar, as you have a black font on a black background colour. Then you can use this formula in cell J3:

=COUNTIF(D3:I3,"Yes")/(6-COUNTIF(D3:I3,"n/a"))

Copy down as required. You can, of course, use anything other than "n/a" - x, for example, but change the second COUNTIF term as appropriate.

Hope this helps.

Pete

If you want to generate the table in the OVERVIEW sheet, then you need to change the entry in cell D3 to Manager rather than Management, then you can use this formula in cell D4:

=AVERAGEIFS(Feuil1!$J:$J,Feuil1!$A:$A,D$3,Feuil1!$C:$C,$C4)

Copy across into E4, then copy both formulae down as required.

Hope this helps.

Pete