#1   Report Post  
Connie Martin
 
Posts: n/a
Default 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
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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

  #3   Report Post  
Connie Martin
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
Countif ??? terryv Excel Worksheet Functions 2 November 8th 04 09:03 AM
countif reno Excel Worksheet Functions 5 November 5th 04 12:20 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM
combining countif formulas Liz G Excel Worksheet Functions 3 November 1st 04 09:34 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"