I'm really new to Google Sheets and formulas in general. I know you can count occurrences of values when you know what you're counting e.g. the times red is written in the column and you can search for the word specifically, but I just want to make a count of how many times things appear.
For example;


My list would continue and I don't know what name is going to come next or I won't be keeping track of the names being put on so I can't tell it to search for a specific name.
Is there a way to tell Google Sheets to keep a tally of the occurrences and keep track and update when a new name is added to the list?

  • 1
    Welcome. Please add more details, like where the input data will be allocated in your spreadsheet and a brief description of your search/research efforts as is suggested in How to Ask.
    – Rubén
    Dec 9 '19 at 23:36
  • 1
    Welcome. You are in the right place - Google Sheets can do some amazing things. But our ability to help is limited to understanding "exactly" what you are trying to do, and the problems you are facing. Prepare a spreadsheet with some test data and share it (put the link in your question); and in the same spreadsheet prepare an example of how you want the outcome to look- you don't have to use any formula, just write the data on a page so that we can understand how things need to appear.
    – Tedinoz
    Dec 10 '19 at 2:03
  • Please also remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Dec 11 '19 at 1:50
  • 1
    @Rubén Please remember that you could upvote both the answer as well as the question. Dec 11 '19 at 3:16

The formula you need is:

=arrayFormula(Countif(A2:A, Filter(A2:A, A2:A <> "")))

count occurrences of unknown values

Functions used:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.