Thread: Using =countif formula with drop down box.
View Single Post
 
Old 02-19-2014, 12:44 PM
wchristner's Avatar
wchristner wchristner is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Feb 2014
Location: Indiana North West
Posts: 5
wchristner is on a distinguished road
Default Using =countif formula with drop down box.
I am using Excel 2011 for mac, I have a listbox with 4 options total, I would like to make this sheet work by selecting an option and using the =COUNTIF command for each option. I can get the =COUNTIF command to work just not with a drop down box. I would like to have the option that no matter what a user picks they will get a different answer from the option they pick. Any Ideas on how to do this? Perhaps Marcos?
Thanks for the help.
Last edited by wchristner; 02-19-2014 at 12:46 PM. Reason: Attach File Photos
Reply With Quote