View original (French)

Formulas in Numbers

Solved
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
    1. 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
      1. Anonymous user
        I finally found:
        =COUNTIF(range,"condition")
        0
        1. Anonymous user
          OK - thanks for the feedback ;)
          0