Share this article:

What it does: The COUNTA() function counts the number of cells that are not blank

Plain English: This function is similar to the COUNT() function, but instead of counting only numbers, you’re counting the number of cells that are not blank. In other words, they have SOME value in them.

Arguments: COUNTA(Value1,[Value2])

  • Value1 – The first value you want to check
  • Value2 – Optional – The second value you want to check
Please remember that we may receive commissions when you click our links and make purchases