How do I count the number of cells that contain a particular value in a specific column.

How do I count the number of cells that contain a particular value in a specific column.

GlyndwrGlyndwr Posts: 117Questions: 32Answers: 0

How do I count the number of cells that contain a particular value in a specific column (e.g., the value "J" in column 8).

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 20,302Questions: 26Answers: 4,769
    Answer ✓

    Use the filter() API. You should be able to use something similar to the first example in the docs then chain the count() API to get the number of results.

    Kevin

This discussion has been closed.