# Adding days and half days in an Attendance sheet

1. ## Adding days and half days in an Attendance sheet

Hello,

I am keeping an attendance at work and I have to total the workers Sick days. I currently have two Total lines:

1 Total line that sums up the accumulated FULL sick days: =COUNTIF(D9:D269,"S") and the other
1 Total line that sums up the accumulated HALF sick days =COUNTIF(D9:D269,".5S")

I would like to only have one Total line, therefore, is there a way and what formula do I have to use in the TOTAL cell to add up days in half days too? I tried =SUM(COUNTIFS(D9:D269,{"S",".5S"})) but this adds full days only.

Thank you.
Felix

2. ## Re: Adding days and half days in an Attendance sheet

The simplest way is just to add your formulae together and include a factor of 2.

To count in whole days (so getting results such as '6.5' whole days off):
Formula:
`Please Login or Register  to view this content.`

To count in half days (so '13' means 13 half-days, equivalent to 6.5 whole days):
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Adding days and half days in an Attendance sheet

It doesn't work. I don't know how the factor 2 will help me. Maybe I don't make myself understood. I apologize. Excel is not my forte and English is not my first language.
I need to be able to input full day (S) and half days (.5S) and add up with decimals. So if I input 4 occurrences of full sick days and 3 occurrences of half days the total line will add to 5.5 days.

See picture with your 2*+ factor formula, it doesnt work.
Thank you.

ATTENDANCE.JPG

4. ## Re: Adding days and half days in an Attendance sheet

There must be something I don't understand about your request, sorry, probably related to how the data is being entered or formatted.
This should certainly be possible and I don't think it will be very complicated, but I can't work out the problem from a picture, so please attach a sample workbook instead.
Make sure there is enough data to demonstrate your need but not so much that the file is too big (if you have hundreds of columns of data, you don't need to leave them all in, for example). Include before and after sheets in the workbook if needed to show the process you're trying to complete or automate. Make sure you include the answers you want to get - put examples in, with notes if necessary to explain details.
Remember to remove any confidential information or, if a cell needs data in it to work, overwrite it with made-up data.
The paperclip icon doesn't work at the moment, so click on Go Advanced under the reply box and then scroll down to Manage Attachments to attach a file.

5. ## Re: Adding days and half days in an Attendance sheet

OK, I attached the document, the Sick occurrences are under Joe Doe. He takes a day Sick and another half of day sick. I want to have the total showing 1.5 days not two entries of 1 full day and 1 half day.

6. ## Re: Adding days and half days in an Attendance sheet

=SUM(COUNTIFS(D9:D269,{"S",".5S"})*{1,0.5})

work the same as

=COUNTIF(D9:D269,"S")+COUNTIF(D9:D269,".5S")/2

7. ## Re: Adding days and half days in an Attendance sheet

Yes, this is what I was looking for.
Thank you very much and sorry again if i didn't make myself understood. I don't have any training in Excel but learning a lot from here.

Have a great day!

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