• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

How to SUM up the number of cells in a column in an excel file

Hi , i have an excel file and i have 5 lastnames in column A. I want to automatically sum up these cells and of course get the number 5. How can i do this ?

2 Solutions
You want to COUNT, not SUM, right?

COUNTA will count all nonblank cells in the specified range.

If you are looking for specific words, you could use COUNTIF

=COUNTIF(A:A,"Smith") ---- would count all occurrences of "Smith" (not case sensitive)
Kannan KManager - EngineeringCommented:

CountA function will ignore the empty cells, it will count where the value is there in specified range.
so you can use the below function itself.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now