You are currently viewing How to count cells that are greater than 0

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 on 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.


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 imaginary 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.