Ask Your Question

How to count same cells in several columns in LibreOffice Calc? [closed]

asked 2013-05-07 13:31:13 +0200

vpviolin gravatar image

I want to count the content (text and numbers) of same cells in several columns. is this possible? i have tried COUNTIF but i'm getting Err:510. e.g. range A1:B40 criteria =A1:B40 Thanks a lot in advance!

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 14:00:19.902827


Can you give a bit more detail? For example, tell us explicitly what column A, B, C etc. contains and the type of data in each column and how you want to count it. Match a certain condition? Match multiple conditions?

oweng gravatar imageoweng ( 2013-05-07 13:35:09 +0200 )edit

2 answers

Sort by » oldest newest most voted

answered 2014-01-10 06:36:32 +0200

SirGouki gravatar image

This is the correct usage of COUNTIF():

=COUNTIF(Range(cells that have the data), Criteria(the IF part))

So for example, Tonight I wanted to check if Cells C2 through C151 have a Y value. To do this I placed the function:


You MUST put the "" if you're checking for a string value (words or letters). This will return the number of cells that meet the criteria in the cell the function is assigned to, in my case at this point in time, is 126.

edit flag offensive delete link more

answered 2013-10-02 22:51:03 +0200

Ahmad gravatar image

updated 2013-10-02 22:53:25 +0200


COUNT() can only count cells with numbers, all cells without numbers will be ignored, to include them use COUNTA().

For you it will be: =COUNTA(A1:B40)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-05-07 13:31:13 +0200

Seen: 1,677 times

Last updated: Jan 10 '14