Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on May 22, 2020 2:05 AM

Reply
Question marked as Best reply

Posted on May 22, 2020 3:06 AM

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

5 replies

COUNTIF for pop up menu's

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.