Hello
Can somebody help with a formula for the below?
I have the following information, and want to calculate the percentage complete based on a value in column a.
So column a contains a task number, and column I contains the percentage complete for the task:
1 20%
2 10%
1 5%
1 100%
3 50%
2 25%
4 9%
I want a formula in a different sheet to provide the total percentage complete for each task. So, where column A = 1, bring back a percentage (so adding up all percentages for every "1" task and dividing by the number of "1" tasks.
Hope that makes sense.
Thanks in advance....
Bookmarks