Countif

[chemexhants]

I am attempting to use the COUNTIF function to count the number of cells in a column containing '0' (zero) but the command also counts cells containing a number including a zero, eg. 82.90.

Is there an easy way to get around this or should I be using a different function?

I am using Excel 2007 and XP.

Stephen

 

[RoryA]

To count zeroes:
=COUNTIF(range,0)

 

[Weaver]

Welcome to the board.

Could you publish the formula as you have it currently?

I've not seen this behaviour before with that particular formula. I'm using 2003, but I can't see why they would've changed the formula this way for later versions.

 

[chemexhants]

Thanks for the very prompt replies. I'm using

=COUNTIF(C8:C252,"=0")

But have also tried

=COUNTIF(C8:C252,0)
=COUNTIF(C8:C252,"=<1")

 

[RoryA]

COUNTIF will not count 82.90 with that formula, so there must be something else going on.

 

[chemexhants]

The original data has been extracted from Sage Line50 accounts into an Excel workbook. The worksheet I am trying to calculate takes the information via a Hyperlink. Could this be causing the issue?

 

[RoryA]

What exactly do you mean by "takes the information via a Hyperlink"?

 

[chemexhants]

Rory

Excuse the terminology, I am very new to Excel!

The command used is =HYPERLINK('Worksheet'!Cell) to link the front worksheet to that containing the Sage data.

 

[RoryA]

Are you saying that C8:C252 have the hyperlink formulas in them?

 

[chemexhants]

Yes they do, and it is in this range that I am trying to count the cells with only 0 in them.