Determine the percentage of a range of cells with a certain value
 

Hi
If the Working, Waiting and Done are all in one column (with heading
Status say) of a table then use a Pivot Table.
In Excel2007
1. Click anywhere in the table and do Insert, Pivot Table. Say yes to
a separate sheet
2. Drag the Status heading to the Row Area of the Pivot Table
3. Drag a "second" Status heading to the Values Area of the Pivot
Table

The default setting of the Values area is Count. If it is not on Count
then click the Values dropdown, Select Values Field Settings and
switch to Count. Also in the Values Field Settings dialog box you can
Show values as...% of Total. Done!

If your table is not organised into columns then...you are making
things difficult for yourself..
regards
Paul





On Feb 3, 4:23*am, Linck Schlich wrote:
So, I have a checklist. *For each Item, there is a drop-down list
indicating different options, (Working, Waiting, and Done). *I would
like to capture the percentage of those cells in a range whose value
is "done" and indicate that percentage in a cell in a separate
workbook.

Thank you for any help!

Determine the percentage of a range of cells with a certain value
 

On Feb 3, 9:58*am, Paul Robinson wrote:
Hi
If the Working, Waiting and Done are all in one column (with heading
Status say) of a table then use a Pivot Table.
In Excel2007
1. Click anywhere in the table and do Insert, Pivot Table. Say yes to
a separate sheet
2. Drag the Status heading to the Row Area of the Pivot Table
3. Drag a "second" Status heading to the Values Area of the Pivot
Table

The default setting of the Values area is Count. If it is not on Count
then click the Values dropdown, Select Values Field Settings and
switch to Count. Also in the Values Field Settings dialog box you can
Show values as...% of Total. Done!

If your table is not organised into columns then...you are making
things difficult for yourself..
regards
Paul

On Feb 3, 4:23*am, Linck Schlich wrote:







So, I have a checklist. *For each Item, there is a drop-down list
indicating different options, (Working, Waiting, and Done). *I would
like to capture the percentage of those cells in a range whose value
is "done" and indicate that percentage in a cell in a separate
workbook.

Thank you for any help!

THANKS!!!