| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine the percentage of a range of cells with a certain value | Excel Programming | |||
| Determine the text in a range that covers several cells | Excel Programming | |||
| Determine if range has NO Blank Cells without looping through each cell in range | Excel Programming | |||
| Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
| determine if cell address is within a range of cells | Excel Programming | |||
Linear Mode
