Hello,
I need help with calculating completed tasks that appear on random rows. I'm already using the formula =COUNTA(XX:XX)/COUNTA(XX:XX) but need it to automatically recognize which range of cells to apply the formula to. In the attached file, the projects are bolded and color filled. Column G calculates the non-bold/non-color filled cells below it that are completed which is indicated by an "X". The number of tasks below each project varies and currently we need to copy the formula and manually indicate which cells to calculate. Is there a formula or VBA code that can determine which of the following cells to calculate based on color fill or bold font? Any other ideas to make this work simpler without having to change the cell range for each project? I hope I explained my question well enough.
Bookmarks