Comments on: Google Sheets COUNT and COUNTA functions with formula examples

Learn how to count the number of cells with various data types. What data is processed by COUNT? How does COUNT differ from COUNTA? What can I count with these functions? Find out the answers to these and some other questions in today's article. Continue reading →

Table of contents

Comments page 2. Total comments: 53

  1. How to count the characters in one cell?

    1. Hello Vince,

      To get the total of chars in a cell, use the LEN function:
      =LEN(A2)

      To count all occurrences of a specific character in a cell, say, the letter "a", the formula should be like this:
      =LEN(A2)-LEN(SUBSTITUTE(A2,"a",""))

  2. HI I NEED HELP .. I NEED TO COUNT THE DATE FROM TO A DAY TODAY

    1. Hi John,

      Do you need to add/subtract some number of days from today's date? Or do you need to get the number of days between two days? Please describe in detail what data you have and what you're trying to do.

  3. Can a counter be made in sheets to display the number of times a name appears on the spreadsheet

  4. Hi,
    How do I calculate the over break instance in gsheet per headcount per month?
    Thank you

  6. Hi,

    How do i calculate total days, if the date are given from and to? please help

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)