Link to home
Start Free TrialLog in
Avatar of c_hockland
c_hocklandFlag for Greece

asked on

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 ?

ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kannan K
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,