Hi all,
I'm trying to create a spreadsheet that tracks tasks completed. For example, their might be 10 categories of tasks and 10 tasks for each category (100 total, for example)

I'm putting each category on a separate sheet. So column A will be populated with names and then B-K would be the 10 tasks for that category. As a person completes one, I would check it off or blacken the box (not sure yet).

Anyway, what I would like is for the next column to hold the percentage of the tasks the person has completed for THAT sheet. AND if possible I would like to track each persons total percentage on a final sheet. Hope that makes sense, I haven't found much on this yet, so any help is appreciated as always. Thanks!