ExcelBanter - How to count the occurrence?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to count the occurrence? (https://www.excelbanter.com/excel-discussion-misc-queries/198303-how-count-occurrence.html)

Eric

How to count the occurrence?

Does anyone have any suggestions on how to count the values? which is no
zero. For example, there is a list of numbers under column A,
100,2,0,3,6,0,5,3
I would like to count the number, which is not equal to zero, and it should
return 6 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Infinitogool

How to count the occurrence?

Hi Eric

Try
=COUNTIF(A1:A8,"<0")

Regards,
Pedro J.

Does anyone have any suggestions on how to count the values? which is no
zero. For example, there is a list of numbers under column A,
100,2,0,3,6,0,5,3
I would like to count the number, which is not equal to zero, and it should
return 6 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Mike

How to count the occurrence?

Change A1:A10 for your needs
=COUNTIF(A1:A10,"<0")

"Eric" wrote:

Does anyone have any suggestions on how to count the values? which is no
zero. For example, there is a list of numbers under column A,
100,2,0,3,6,0,5,3
I would like to count the number, which is not equal to zero, and it should
return 6 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

joel

How to count the occurrence?

=COUNTIF($A:$A,"0")

"Eric" wrote:

Does anyone have any suggestions on how to count the values? which is no
zero. For example, there is a list of numbers under column A,
100,2,0,3,6,0,5,3
I would like to count the number, which is not equal to zero, and it should
return 6 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

All times are GMT +1. The time now is 07:37 PM.