1. Home

Excel COUNTA Function

The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters

COUNTA Function

The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters.

It is typed =COUNTA

How to use the =COUNTA function:

  • Select a cell
  • Type =COUNTA
  • Double click the COUNTA command
  • Select a range
  • Hit enter
    • Let's see some examples!

    Apply the =COUNTA function to range A2:A21, counting Pokemons by their names, which are letters only:

    COUNTA function, step by step:
  • Select A23
  • Type =COUNTA
  • Double click COUNTA in the menu
  • Select range A2:A21
  • Hit enter

    • The COUNTA function has successfully counted 20 cells with values in the range A2:A21.

    Lets apply the COUNTA function to D2:D21. Counting a range with numbers only.

    That is great! The COUNTA function counts cells in a range with values both numbers and letters.

    function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }

    Categories

    HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

    Contact US