Hi,
I have a a drop down with 12 options including the Outcome option and I want to pull a numerical value for the amount of times each option is selected. Ive tried using the countif formula and the individual option like COUNTIF(Scott::Table 1::M2:M289,"No Answer" which gives a result of 0. I have also tried to include every option of the pop up and it still does the same thing. Is there a way to get this data?
Thanks Scott.
MacBook Pro 13", macOS 10.15
Not sure what you mean. They are in my Col M, as you specified in your original post:
Make sure the spelling is EXACTLY the same in your summary table as it is within the Pop-Up Menu.
SG
Hi,
The outcomes in Col M are not in a pop up menu though where you select a text box from a list of pre determined drop downs.
thanks,
For me this still returns a result of zero with the formula COUNTIF(Scott::Table 1::M2:M289,B$1) or Changing B$1 to the term I'm trying to get from the pop up menus, it also does the same if I select the entire column rather than the range of cells.
Thanks,
Sorry you're right there was a space at the end of the word on the drop down but not in the formula. Thanks so much :)
Scott
This works fine here:
The formula in B2, filled down:
=COUNTIF(Table 1::M,A2)
This assumes you are in a region that uses . as the decimal separator. If your region uses , as a decimal separator, then change the , in the formula to a ;
SG
COUNTIF for pop up menu's
