View original (French)

Formulas in Numbers

Solved
Anonymous user -  
 Anonymous user -
Hello everyone,

I created a local menu (a drop-down list) on a Numbers document.
Each field in the "category" column is the list with the different values.
I would like, when I select values from this list, for these items to be counted somewhere.

What would be the formula for that?

Thanks for your help.

4 answers

  1. Anonymous user
     
    Hello,

    Not really sure I understood the question, but just in case:

    0
  2. Anonymous user
     
    it’s a good start ;)

    i have 50 fields in the "category" column.

    and i would like that in the "category results" section it counts the number of "Geography", "History" ... that i will have selected in the "category" column.

    I’m not sure if that’s clearer?

    0
  3. Anonymous user
     
    I finally found:
    =COUNTIF(range,"condition")
    0
  4. Anonymous user
     
    OK - thanks for the feedback ;)
    0