We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

COUNT command with a column of numbers

asked 2021-05-05 21:45:48 +0200

max2 gravatar image

updated 2021-05-06 18:37:25 +0200

BigRAl gravatar image

Suppose that I have a column of numbers in of this shape:

22 100,10


Now, I need a command containing the key-word =COUNT which would count the number of occurrences of the numbers equal to -78. What this command should be ?

edit retag flag offensive close merge delete


retag because obviously its not about math but calc

karolus gravatar imagekarolus ( 2021-05-06 12:59:51 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-05-05 22:03:46 +0200

Opaque gravatar image



A1 contains 22
A2 contains 100,10
A3 contains -78

use: =COUNTIF(A1:A3;-78)

edit flag offensive delete link more


It works fine, thank you. BTW how do I compute the real number 2/3 so that the output would be 0.6666667 within a cell? I've tried /,div,divide,division with no success.

max2 gravatar imagemax2 ( 2021-05-05 22:25:01 +0200 )edit

Use =2/3

Opaque gravatar imageOpaque ( 2021-05-05 22:27:36 +0200 )edit

Why do you mention "closing the question" in your last comment ? I wouldn't do that, someone else is considering to do it ? Thank you for an explanation, I'm quite new here.

max2 gravatar imagemax2 ( 2021-05-05 22:32:05 +0200 )edit

Why do you mention "closing the question" in your last comment ?

Were do your read that from "Use =2/3", which is my last comment? There is no need to close a question (I'm not the author of any automatic email you may receive from the system)

Opaque gravatar imageOpaque ( 2021-05-05 22:41:00 +0200 )edit

There was written "there is no need to close the question" some seconds ago in that comment ...just below =2/3

max2 gravatar imagemax2 ( 2021-05-05 22:44:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-05-05 21:45:48 +0200

Seen: 32 times

Last updated: May 05