Calculating Half Days in Attendance

1. Re: Calculating Half Days in Attendance

Using Exact()

=SUM(SUMPRODUCT(--EXACT(C6:AG6,"p"))*0.5,COUNTIF(C6:AG6,"EL/P")*0.5,COUNTIF(C6:AG6,"P"))

Or

Using Find()

=SUM(SUMPRODUCT(--ISNUMBER(FIND("p",C6:AG6)))*0.5,COUNTIF(C6:AG6,"EL/P")*0.5,COUNTIF(C6:AG6,"P"))

2. Re: Calculating Half Days in Attendance

Hello,

I know this thread is very old but it is the closest to my question.

I am also keeping an attendance and I have to total for Sick days. I have two Total lines:
1 Total line is recording the accumulated sick days: =COUNTIF(D9:D269,"S") and the other
1. Total line is recording the accumulated half of days sick =COUNTIF(D9:D269,".5S")

I want to only have one Total line, therefore, what formula do I have to use for the chart to add days in half days too? I tried =SUM(COUNTIFS(D9:D269,{"S",".5S"})) but this adds full days only.

Thank you.

3. Re: Calculating Half Days in Attendance

Felix_I welcome to the forum

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

4. Re: Calculating Half Days in Attendance

I apologize, I will start a new thread.

Page 2 of 2 First 1 2

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