Forum Discussion
Solved
Attendance Team and manager wise
Attached the sample attendance sheet, I need the attendance list team wise daily and lead wise present data.
NAME OF EMP
Team
Lead
01
02
Fri
Sat
Kamal Krishnan
A
...
That could be
=COUNTIFS(XLOOKUP(B$15,$D$1:$AH$1,$D$3:$AH$14),"P",$B$3:$B$14,$A16) and =COUNTIFS(XLOOKUP(B$22,$D$1:$AH$1,$D$3:$AH$14),"P",$C$3:$C$14,$A23)drag them to the right and down
Could you please clarify what shall be the result, it will be great if you add manually for one-two days. Sorry, I didn't catch what exactly is required.
