COUNTIF for pop up menu's
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