Calculating Percentage Complete

Hi all,

I'm trying to create a spreadsheet that tracks tasks completed. For example, there might be 10 tasks for each user and each user is on a different tab. On each tab I want to calculate the percentage of tasks marked Not Started, In Progress and Completed for that user. And on the last tab I want to calculate the same but for all users combined.

I've attached a simple version of what I'm trying to do so you can see what formulas, etc I will need to use.

Demo.xlsx

Thanking you in advance!

Gary

See your modified workbook attached.

Hi Dennis, thank you sooo much! Absolute lifesaver.

Gary