Aladin
Posted by Brian on January 16, 2002 6:34 AM
Aladin,
Here is the formula:
=SUMIF('[VACATION CALENDAR.xls]JAN.'!$A$1:$H$100,"Employee Name",'[VACATION CALENDAR.xls]JAN.'!$B$1:$B$100)
It seems to search for the name in both columns B and G and adds the hours in C and H.
Sorry for the delay it's 4:30am in Hawaii, and I'm going to work right now. Thanks in advance. I don't have internet access at work.
Brian
Posted by Aladin Akyurek on January 16, 2002 7:19 AM
Brian --
Make that:
=SUMIF('[VACATION CALENDAR.xls]JAN.'!$B$1:$B$100,"Employee Name",'[VACATION CALENDAR.xls]JAN.'!$C$1:$C$100)+SUMIF('[VACATION CALENDAR.xls]JAN.'!$G$1:$G$100,"Employee Name",'[VACATION CALENDAR.xls]JAN.'!$H$1:$H$100)
if you expects an emplyoe name to occur in B as well as G.
And, What is in A?
Aladin
==============
Posted by Brian on January 16, 2002 9:03 AM
Aladin,
Thanks!
Column A and F has a shift time
column D and I has a reason for hours
Column F and J has who authorized the hours
Brian
