LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Query not returning correct results?! Webtechie Excel Discussion (Misc queries) 4 August 7th 09 01:45 PM
Getting correct results for lookup? tgcali Excel Discussion (Misc queries) 4 July 15th 08 02:32 AM
what formulas will give correct results TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 February 26th 07 02:13 AM
How do I get correct results when LOOKUP with calculated numbers onthemountain Excel Worksheet Functions 2 July 20th 06 01:13 AM
My IF(AND passes logical, but doesn't reveal correct results Washdc Excel Worksheet Functions 6 July 31st 05 05:10 AM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"