Workout overall percentage of completed tasks

Hi guys,

I have X amount of tasks in column B, and column H shows the progress of each task in %. What I need is a formula to workout overall percentage of completed tasks. For example 2 tasks are 100% complete and two tasks are 50% and 60% complete. So If I had 22 tasks, what would be the overall %. I've attached a sample to help you understand what I'm trying to say

Thanks guys.

PUt this formula in A1 :

HTML Code: 

this above formula will calculate upto your 22 Tasks, which is completed in Row 28, if you want to expand your task then expand your Range in formula.


If it was really helpful to you then dont forget to hit * button for user reputation.


Regards
CA Mahaveer Somani

Originally Posted by mahaveersomani

PUt this formula in A1 :

HTML Code: 

this above formula will calculate upto your 22 Tasks, which is completed in Row 28, if you want to expand your task then expand your Range in formula.


If it was really helpful to you then dont forget to hit * button for user reputation.


Regards
CA Mahaveer Somani

Thanks Mahaveer, that worked brilliantly