On 2002-03-19 08:31, Acody wrote:
Aladin, Thanks for your continued help : )
The range for "jobnumber" is:
B9 to K9
B16 to K16
(everything in the square above).
B14:B16 are the job numbers from week one that I have on my timesheet.
B30:B32 are the job numbers from my second week, and on the second week I added one new job that I did not work on the first week.
So when I plug in my formula for the new job my cell reads N/A...b/c my formula wants to pull a number from week #1.
I want my formula to look to week one for a similiar job number, if it does not find one, then add only the hours worked on that job for week two.
K31 it a sum of the hours I worked on that job for week two. K31 is the cell I want my formula to refer to if week one does not have the same job number as week two.
Sorry that this is so confusing! : )