ExcelBanter - COUNTIF

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF (https://www.excelbanter.com/excel-worksheet-functions/7661-countif.html)

Connie Martin

COUNTIF

I have a simple formula: =COUNTIF(O14:O100,"0")
And I have a simple question: I want it to count from and including zero,
not just more than zero. How do I include zero in that?

Connie

Peo Sjoblom

=COUNTIF(O14:O100,"=0")

Regards,

Peo Sjoblom

"Connie Martin" wrote:

I have a simple formula: =COUNTIF(O14:O100,"0")
And I have a simple question: I want it to count from and including zero,
not just more than zero. How do I include zero in that?

Connie

Connie Martin

I knew it was simple! Thank you very much!

"Peo Sjoblom" wrote:

=COUNTIF(O14:O100,"=0")

Regards,

Peo Sjoblom

"Connie Martin" wrote:

I have a simple formula: =COUNTIF(O14:O100,"0")
And I have a simple question: I want it to count from and including zero,
not just more than zero. How do I include zero in that?

Connie

All times are GMT +1. The time now is 07:27 AM.