How to count cells that are greater than 0

Counting is the act of tallying a certain quantity to obtain or to reveal the number of items or several objects in a set. Counting can be general and done in almost all aspects of life or our daily routines.

In most cases, we do the tallying or the counting in numerical values that involve the use of numbers. The majority of activities or scenarios we happen to come across in our daily lives will always involve counting in one way or the other. Nearly everything depends on or revolves around counting in this world.

Counting values greater than or less than is just obtaining the numeric value of values larger than or less than 0. Greater than is another word used in the place of larger than or huge than, or higher than to mean big.

We adopt some of the following steps to guide us in the counting of cells greater than 0 in any given data set or scenario in excel sheets.

Steps to count cells greater than 0

1. To do the counting of the cells first you need to have the dataset to use in place or ready. To do this, open an excel sheet and create some dummy data into it as in the case below.

2. The next step is to get the count of all the cells which happen to be greater than 0. We do this with the help of a formula; COUNTIF. In our data set, if we need to find the count of cells greater than 0 as from cell A1 all the way to cell C1, we type the formula in the formula bar in this format =COUNTIF (A1: C1,">0")

Upon clicking on the enter button, the formula will count for you and return the cell values that are greater than 0 in the selected cells. For our case, the cells that have values greater than 0 is 2, this is to mean the two values are greater than 0 or are positive numbers, unlike the ones that are negative which will be less than zero.

How to count Cells greater than or equal to zero

1. Assuming we have the following set of data

2. Select an empty cell,

3. Enter the following formula on the formula bar and press enter, =COUNTIF(A1: C5,">=0")


How to count cells with values less than zero

1. Let's use the following data as our example to count cells with values less than zero

As you can see we have some negative values in it.  Select an empty cell

2. Enter the following formula on the formula bar and press enter =COUNTIF(A1: C4,"<0")

As you can see we have 5 cells less than 0

%d bloggers like this: