View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ryan F[_3_] Ryan F[_3_] is offline
external usenet poster
 
Posts: 1
Default Linking Checkboxes/Drop Down Lists to a Formula

Hey guys, back with another question.

I am currently making a spread sheet to determine what percentage of phones
we get back are of the following natu

Under Warranty
No Trouble Found
Customer Abuse

I would like to make a drop down list, so our techs can select only one of
those three options (which I know how to do).

Is there a way to link those options into another cell and keep a running
tally of how many of each were chosen? I can go from there and format the
percentages etc...

Happy Friday!
-Ryan