Adding columns to get correct results

K

Katherine

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top