If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 Last edited by Frustrated Word User : November 26th, 2008 at 07:46 PM. |
#2
|
|||
|
|||
zero in cell is counting as one...
=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 |
#3
|
|||
|
|||
zero in cell is counting as one...
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 |
Thread Tools | |
Display Modes | |
|
|