I Wish To Count The Number Of Cells In A Col Or Row That Have A Value > 0. How Is This Done? The Zero Is Displayed In The Cells. Count() Will Only Ignore A Blank Cell?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home MS Excel

⟩ I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

In Excel, you would use something called an array formula. If your range of cells is in A1:A100, you would type the following formula:

=SUM(IF(A1:A100>0,1,0)) instead of hitting enter, you would hit Ctrl+Shift+Enter.

This keystroke tells Excel it is an array formula. It will evaluate each cell in the range, and if it is greater than 0, add 1 to your result. Otherwise, it will add zero to your result.

A second solution in Excel 97 is to use Countif. =COUNTIF(A1:A100,">0")

Is this answer helpful?
0 Yes | 0 No

255 views

More Questions for you:

There are many monetary signs in Excel97 but I have not found one yet for the new euro currency. Any suggestions?

I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

I am new at this Excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column and would like to know the difference?

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return the color of the interior for each cell in a range? I would like to do something like =countif(b1b10, cell("interior","Red"))?

Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?

I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

How can I enter the symbol for the new Euro currency in my spreadsheet?

I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?

I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home MS Excel

⟩ I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home MS Excel

⟩ I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: