c_hockland
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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,