|
|
#1
02-19-2014, 12:44 PM
|
||||
|
||||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 COUNTIF Formula
|
teza2k06 | Excel | 3 | 02-13-2014 12:37 PM |
| if formula that points to a cell with a drop down | bremen22 | Excel | 2 | 02-08-2014 06:22 AM |
| Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
|
Countif with 2 criteria
|
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Mac OS X 
Office for Mac 2011
Threaded Mode