# Help me! I want to count the working days of worker with count and if array.

1. ## Help me! I want to count the working days of worker with count and if array.

Mon Mon Mon Tue Tue Tue Wed Wed Wed Thu Thu Thu Fri Fri Fri Sat Sat Sat Sun Sun Sun Mon Mon Mon Tue
x x 2 x x 5 x x 1 x x x x x x x x x x x

The workers works 2 shift: morning and afternoon, and they sometime work overtime at night (counted by hours).
1>I want to set up the formula to count the working days for the worker to count the normal working days (exclude overtime and Sunday)
{=COUNT(IF((A1:Y1<>"Sun"),A2:Y2,0))/2} (array formula)

The correct answer should be 7.5 but it turns out 5.

2>I count working days in sunday by {=COUNT(IF((A1:Y1="Sun"),A2:Y2,0))/2} ==>the answer is 11.5 while the correct one should be 1.

3>I want to add the overtime working by =SUMIF(A2:Y2,ISNUMBER(A2:Y2))/8 and it does not work also. (the right result should be 8h)

Can anybody help me to fix this??

Thanks alot.

2. ## Re: Help me! I want to count the working days of worker with count and if array.

Sorry, I want to attached the excel file, but i do not know how to. can anybody show me?

Tks,

3. ## Re: Help me! I want to count the working days of worker with count and if array.

Hi and welcome to the forum

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1