Percentage of an Element ...
I want to know the percentsge of completion of an Element, containing 7 items
of % of completion, either as a completion rate of over 90%, and or 100%. Element 1.1 = 86% cell E6 Element 1.2 = 100% cell E14 Element 1.3 = 29% cell E19 Element 1.4 = 75% Cell E27 Element 1.5 = 0 % cell E32 Element 1.6 = 0 % Cell E38 Element 1.6 = 38% cell e41 |
Percentage of an Element ...
I have three household tasks to complete and this is what I have done so far
1.1 Vacuum 6 rooms: 0% 1.2 Clean all windows in 6 rooms: 0% 1.3 Empty the dishwasher: 100% On average I have done (0+0+100)/3 = 33.3% of the tasks. True in a sense but not very meaningful since 1.1. and 1.2 take much longer than 1.3. But is this is NOT so in your case, then use =AVERAGE(E1, E14, E19, E27, E32, E38, E41) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Magic1" wrote in message ... I want to know the percentsge of completion of an Element, containing 7 items of % of completion, either as a completion rate of over 90%, and or 100%. Element 1.1 = 86% cell E6 Element 1.2 = 100% cell E14 Element 1.3 = 29% cell E19 Element 1.4 = 75% Cell E27 Element 1.5 = 0 % cell E32 Element 1.6 = 0 % Cell E38 Element 1.6 = 38% cell e41 |
All times are GMT +1. The time now is 12:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com