complicated function in excel
 

I have a schedule spreadsheet that I modified that has the times listed
across the top and you type the employees name in each hour cell and at the
end it totals the hours worked. (FORMULA IS: =SUM(IF(ISTEXT(C6:K6),1,0)) )
I want to add a page that will "find" the employees names on each of 7 pages
(one for each day of the week)and their hours worked and total them on the
last page. Let me know if it would be helpful to send you the sheet. Thanks
in advance.
--
kelkel

Hi!

I'll take a shot at it.

Post your address and I'll contact you.

Biff

"kelkel" wrote in message
...
I have a schedule spreadsheet that I modified that has the times listed
across the top and you type the employees name in each hour cell and at
the
end it totals the hours worked. (FORMULA IS:
UM(IF(ISTEXT(C6:K6),1,0)) )
I want to add a page that will "find" the employees names on each of 7
pages
(one for each day of the week)and their hours worked and total them on the
last page. Let me know if it would be helpful to send you the sheet.
Thanks
in advance.
--
kelkel

my address is:

"Biff" wrote:

Hi!

I'll take a shot at it.

Post your address and I'll contact you.

Biff

"kelkel" wrote in message
...
I have a schedule spreadsheet that I modified that has the times listed
across the top and you type the employees name in each hour cell and at
the
end it totals the hours worked. (FORMULA IS:
UM(IF(ISTEXT(C6:K6),1,0)) )
I want to add a page that will "find" the employees names on each of 7
pages
(one for each day of the week)and their hours worked and total them on the
last page. Let me know if it would be helpful to send you the sheet.
Thanks
in advance.
--
kelkel

Hi!

Ok, sent you an email.

Biff

"kelkel" wrote in message
...
my address is:

"Biff" wrote:

Hi!

I'll take a shot at it.

Post your address and I'll contact you.

Biff

"kelkel" wrote in message
...
I have a schedule spreadsheet that I modified that has the times listed
across the top and you type the employees name in each hour cell and at
the
end it totals the hours worked. (FORMULA IS:
UM(IF(ISTEXT(C6:K6),1,0)) )
I want to add a page that will "find" the employees names on each of 7
pages
(one for each day of the week)and their hours worked and total them on
the
last page. Let me know if it would be helpful to send you the sheet.
Thanks
in advance.
--
kelkel