Calculating Half Days in Attendance

Add a Sum(), because Array in Criteria needs some in front of Countif

=COUNTIF(I123:AM123,"P")+(SUM(COUNTIF(I123:AM123,{"SL/P","EL/P","CO/P"}))/2)

=COUNTIF(I123:AM123,"P")+COUNTIF(I123:AM123,"*/*")/2
Try this

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

=SUMPRODUCT(((CODE(LEFT(I123:AM123&"-",1))=80)+(CODE(LEFT(I123:AM123&"-",1))=112)/2))+COUNTIF(I123:AM123,"*/*")/2
try this

If you have P or p in the cell
=CODE(I123:AM123) will give it will give 80 or 112
if you have an empty cell it will give "#VALUE!"
so that I added "-" to the cell
to get the only one letter from cell I used left function

for more details select formula from toolbar
then select the Evaluate Formula then click on evaluate keep on click on evaluate, here you will find how the formula is working

Or

You can use Exact() function as an alternative to Code()

I was just checking how good does this work, i copied the attendance data & the formula from just a single line & pasted it on a blank excel sheet, i tried adding lower case "p" to each cell but the count is taken only after typing in two cells, but when i type "p" in third cell total count still shows same count as previous.

Please advice me how to go about this.

You want me to take the formula as
=SUMPRODUCT(((EXACT(LEFT(I123:AM123&"-",1))=80)+(EXACT(LEFT(I123:AM123&"-",1))=112)/2))+COUNTIF(I123:AM123,"*/*")/2 ??

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"))

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.

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.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new 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.