Adding columns to get correct results
 

In using the following formula I encounter a problem - if
the columns have no information a -1 appears in the total -
is there a way to use this formula and have it recognize
when all cells are empty ? Help thanks - example of what
I am trying to accomplish below


Column A B C D E F G
03/03/04 03/03/4 1 03/03/04 03/05/04 3 3
-1
03/03/04 03/03/04 1 1
03/03/04 03/04/04 2 2
03/03/04 03/04/04 2 03/05/04 03/07/04 3 5
Explanation
My formula has to recognize the first date as day 1 and if
in and out day are the say in the subtraction it is one
not zero - (it is accomplishing this) it must also
recognize that if column B & D are the same D can not be
counted (it is doing this) the problem is when the cells
are completely empty the formula is giving me a total of -
1 or that they owe me one day labor - can you help ???
Thank you

Katherine

Adding columns to get correct results
 

=if(countA(A2,B2,D2,E2)=0,0,currentformula)

--
Regards,
Tom Ogilvy


"Katherine" wrote in message
...
In using the following formula I encounter a problem - if
the columns have no information a -1 appears in the total -
is there a way to use this formula and have it recognize
when all cells are empty ? Help thanks - example of what
I am trying to accomplish below


Column A B C D E F G
03/03/04 03/03/4 1 03/03/04 03/05/04 3 3
-1
03/03/04 03/03/04 1 1
03/03/04 03/04/04 2 2
03/03/04 03/04/04 2 03/05/04 03/07/04 3 5
Explanation
My formula has to recognize the first date as day 1 and if
in and out day are the say in the subtraction it is one
not zero - (it is accomplishing this) it must also
recognize that if column B & D are the same D can not be
counted (it is doing this) the problem is when the cells
are completely empty the formula is giving me a total of -
1 or that they owe me one day labor - can you help ???
Thank you

Katherine