zero in cell is counting as one...

Hello smart people.

I have a workbook to track injuries in the workplace. A cell is set up to calculate the number of injuries from a given year. Here's the thing;

If there is a zero in the column, it is counting that as one. Here is the formula: =COUNTA('2005 Log'!Z8:Z200)

Some of the years let me clear the contents of the cells, and that takes care of it. But some don't let me do that. The cells in question are check x or no x, no numerical value is to be entered. AND the zeros won't go away.

This is probably a basic fix, please let it be and please help me.

Thanks AGAIN.

Joanna

=COUNTA('2005 Log'!Z8:Z200)-COUNTIF(Z8:Z200,0)
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Frustrated Word User" wrote:


Hello smart people.

I have a workbook to track injuries in the workplace. A cell is set
up to calculate the number of injuries from a given year. Here's the
thing;

If there is a zero in the column, it is counting that as one. Here is
the formula: =COUNTA('2005 Log'!Z8:Z200)

Some of the years let me clear the contents of the cells, and that
takes care of it. But some don't let me do that. The cells in
question are check x or no x, no numerical value is to be entered. AND
the zeros won't go away.

This is probably a basic fix, please let it be and please help me.

Thanks AGAIN.

Joanna




--
Frustrated Word User

So, all you want to count are the X's?

=COUNTIF('2005 Log'!Z8:Z200,"x")

--
Biff
Microsoft Excel MVP


"Frustrated Word User" m
wrote in message news:Frustrated.Word.User.37360b8@officefrustratio n.com...

Hello smart people.

I have a workbook to track injuries in the workplace. A cell is set
up to calculate the number of injuries from a given year. Here's the
thing;

If there is a zero in the column, it is counting that as one. Here is
the formula: =COUNTA('2005 Log'!Z8:Z200)

Some of the years let me clear the contents of the cells, and that
takes care of it. But some don't let me do that. The cells in
question are check x or no x, no numerical value is to be entered. AND
the zeros won't go away.

This is probably a basic fix, please let it be and please help me.

Thanks AGAIN.

Joanna




--
Frustrated Word User