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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Determine the percentage of a range of cells with a certain value (https://www.excelbanter.com/excel-programming/445329-re-determine-percentage-range-cells-certain-value.html)

Don Guillett[_2_]

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

Show us layout and example

On Feb 2, 10:23*pm, 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!

All times are GMT +1. The time now is 01:53 PM.