View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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!