Ask Your Question
0

Count columns in Calc [closed]

asked 2014-11-02 00:23:16 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

hello, in Calc ver. 4.2.6, if I select a number of columns, is there a way to count them other than manually? i.e. there are a lot of columns in this file and I just wanna know how many

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-03-05 18:48:34.569796

2 Answers

Sort by » oldest newest most voted
2

answered 2014-11-02 02:30:27 +0200

m.a.riosv gravatar image

I think there are a couple of functions that can help:

COLUMN(Reference)
Reference is the reference to a cell or cell area whose first column number is to be found.

COLUMNS(Array)
Array is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell.

edit flag offensive delete link more
1

answered 2014-11-02 11:48:16 +0200

Lupp gravatar image

updated 2014-11-02 11:49:48 +0200

"... there are a lot of columns in this file and I just wanna know how many[.]"

If there is not intended to apply a function:

If the info field at the right side of the status bar is set to 'Selection count' we get the number of columns by selecting only one (the first?) cell of every column. D1:F1~I1:M1~Q1:S1 selected will show 11, e.g.

edit flag offensive delete link more

Comments

This worked well for me because some of the columns were emtpy and I actually wanted to count only the ones with content, which appears to be what "selection count" does - and because I don't know how to apply functions in Calc, so didn't try that.

bennypr0fane gravatar imagebennypr0fane ( 2014-11-04 14:39:34 +0200 )edit

Just 2 remarks:

'Selection count' does count the empty (blank) cells in a collection as well.

What reason to use Calc if you don't want tu use formulae?

Lupp gravatar imageLupp ( 2014-11-04 16:56:54 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-11-02 00:23:16 +0200

Seen: 4,010 times

Last updated: Nov 02 '14