Ask Your Question
0

How to count the number of cells in a particular column in an excel sheet? [closed]

asked 2014-01-08 12:28:10 +0200

yamini gravatar image

How to count the number of cells in a particular column in an excel sheet?

I have tried shift key and selected the cells which we do normally in MS Office normally ,but it turned to be different in libre office

Can anyone help me ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 13:31:19.586805

1 Answer

Sort by » oldest newest most voted
2

answered 2014-01-08 13:42:05 +0200

ROSt52 gravatar image

A quick way to count is using the functions at the bottom of the spreadsheet:

image description

"Count" counts only cells with numerical entries "CountA" counts cells with alphanumerical entries.

Please also have a look in the help file using the search term "count"

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-08 12:28:10 +0200

Seen: 12,252 times

Last updated: Jan 08 '14