Solved

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

Posted on 2011-03-21
194 Views
Last Modified: 2012-05-11
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 ?

0
Question by:c_hockland
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
3 Comments

LVL 33

Accepted Solution

jppinto earned 250 total points
ID: 35183837
You want to COUNT, not SUM, right?

=COUNTA(A:A)
0

LVL 8

Assisted Solution

ragnarok89 earned 250 total points
ID: 35184208
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)
0

LVL 5

Expert Comment

ID: 35184255
Hi,

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.

=COUNTA(C4:C12)

KK,
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month8 days, 6 hours left to enroll

#### 738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.