Forum Discussion
Attendance Team and manager wise
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
The attached is your problem but the solution uses new methods only available in Excel 365 beta. The recursion required to perform the calculations for each of 31 days as a single calculation is the sort of stuff that fries ones brain so I urge you not to pay it too much attention.
I had to try to fight this one through as a single recursive Lambda function. That it is possible is interesting, but I really struggle getting my senile brain round the challenges of recursion! I am hoping that a future MAP function might make the application of Lambda functions to arrays much easier. Maybe I should take some Python or Haskell training if I am going to get a grip on this. My FORTRAN days do not stand me in good stead!
PeterBartholomew1 , yes recursion with lambdas is not the easiest way to edit and debug, even if with some tricks is possible to do with in-cell edit mode.