# How to Count Cells with Positive Numbers in Excel?

The problem is to count the number of cells in a range that contain positive numbers. For example, if we have a range of cells from A1 to A10, we need to count the number of cells that contain positive numbers.

## Method 1: Using COUNTIF Function

The COUNTIF function is a powerful function used to count cells that meet a specific criterion. In this case, we want to count cells with positive numbers, so we can use the following formula:

``=COUNTIF(A1:A10,">0")``

This formula will count the number of cells in the range A1:A10 that contain a value greater than zero.

## Method 2: Using SUMPRODUCT Function

The SUMPRODUCT function is another way to count cells with positive numbers. This function returns the sum of the products of corresponding values in two or more ranges. In this case, we can use the following formula:

``=SUMPRODUCT(--(A1:A10>0))``

This formula will count the number of cells in the range A1:A10 that contain a value greater than zero.

## Method 3: Using Filter and SUBTOTAL Functions

We can also use the combination of the FILTER and SUBTOTAL functions to count cells with positive numbers. The FILTER function is used to filter the cells that meet a specific criterion, and the SUBTOTAL function is used to count the filtered cells. In this case, we can use the following formula:

``=SUBTOTAL(2,FILTER(A1:A10,A1:A10>0))``

This formula will filter the cells in the range A1:A10 that contain a value greater than zero and then count the filtered cells.

## Method 4: Using PivotTable

The PivotTable is a powerful tool used to summarize, analyze, and present data. We can use PivotTable to count cells with positive numbers. In this case, we can create a PivotTable from the range A1:A10 and then drag the field containing the positive numbers to the “Values” area. Excel will automatically count the number of cells with positive numbers.

In this article, we discussed four different methods to count cells with positive numbers in Excel. These methods include using the COUNTIF function, the SUMPRODUCT function, the combination of the FILTER and SUBTOTAL functions, and PivotTable. We hope you have got the solution. Thank you. ## Bibek Sapkota

I'm Bibek | Tech Enthusiast & Lifelong Learner. | Playing on the Web for the Past Few Years as an SEO Specialist and Full-Time Blogger. I'm constantly seeking out new opportunities to learn and grow, and I love sharing my knowledge with others. This is where I started this blog! Here, you will find me sharing comprehensive reviews, helpful guides, tips-tricks and ways to get the full benefits of evolving technology. On this blog, you can also explore Powerful Knowledge, Tips & Resources On Blogging, SEO and Passive income Opportunities.