Formulas for a attendance sheet

I have 2 shets:
I. The index of all client names(A) and the 2 types of planned sessions(B,C) and actual held sessions(D,E) and absences(F)
II. The Attendance record with date time(A,B) name(C) type of session(D)

I would like to write in the type of session (II-D) a letter like K(for the I-D) H(for I-E) and M(for absence)
I would like it to compute the number of sessions and the type from the second sheet to the first one.

Thank you!

can you provide a sample spreadsheet - so we can see the layout and the outcome you require
i suspect you can use index/match to bring across the details and an IF statement to use any codes

and then a countif or countifs to count the codes and compute the sessions and attendance

but would be useful to see a sample sheets

I wrote 2 types of attendance records. If you could help me implement one of the two i would really appreciate it.

Ok - I have used countIfs
=COUNTIFS('Attendance Record Type one'!$C$2:$C$10,'Monthly Planned'!$A3,'Attendance Record Type one'!$D$2:$D$10,"K")
But there are a lot of manual entered codes for the formula
so it needs to be changed for the different coded

K, H , M

Also it will Not work out any dates - so will not automatically work out the Months data - although this can be done
I have used the sheet ONE as that has codes -

so some changes can also automate this information


I have changed the date - to a real date entry and formatted to show just the day and month

I Have also created a pivot table - to show you the possibility

Added the new table in cells G-K
Added as a table - so as you ADD new rows - it will be available to the pivot table - Just need on the pivot table to hit refresh - and the data comes into the pvt sheet

the pivot sheet named PVT - shows the codes - but that could easily show the names for each of those codes
also the drop down at the top will also change the table to look only at certain months - or that could be on the PVT itself

hope I have not confused

have a look see what you think , and we can redesign to meet your needs

and if you added the planned dates into the 2nd sheets as well - that could also be included

BUT I have automated your monthly sheet - as the original request

Lesoies, Good morning.

I have a little contribution to your question too.

I used the SUMPRODUCT function.
I did a simulation about yours two different type of control.

Take a look at it and tell us if it worked for you.

I hope it helps