Formula for percentage of tasks completed by week?
I'm currently working on a sheet where I would like to correlate a percentage of tasks completed with an individual week number so I can create a line chart to plot % of tasks completed by week.
Currently my formula is =COUNTIF([Week Number]1:[Completed within Scheduled Frequency]16, ="Percentage Complete") but this formula isn't applying to individual weeks, it's applying to the entire column. How would I create a formula that would associate the % of tasks completed for a specific week?
Help Article Resources
Check out the Formula Handbook template!