Roster Count

[Dirtydrongo]

Hey,

Was hoping for some help I am trying to use a countifs function to determine how many employees are rostered on for the current day based on their position. The function used has worked to achieve my end result but I am struggling to get it to increment based on current days date.

Goal= To know how many Position '#1, #2, #3' are rostered on for each current day (note DSW= working, RNR= time off. And how many are on annual leave (AL)

=COUNTIFS($B$3:$B$10,$A$15,$M$3:$M$10,"=DSW") Used to determine Cell B15

Any assistance would be appreciated.

 

[Cubist]

Doing this by eye so the formula might be off, but try this for positions #1,2,3

=LET(f,FILTER($D$3:$O$10,$D$2:$O$2=TODAY()),IFERROR(ROWS(FILTER(f,($B$3:$B$10=A15)*(f="DSW"))),0))

....and this for AL

=LET(f,FILTER($D$3:$O$10,$D$2:$O$2=TODAY()),IFERROR(ROWS(FILTER(f,f="AL")),0))

 

[Dirtydrongo]

Doing this by eye so the formula might be off, but try this for positions #1,2,3

=LET(f,FILTER($D$3:$O$10,$D$2:$O$2=TODAY()),IFERROR(ROWS(FILTER(f,($B$3:$B$10=A15)*(f="DSW"))),0))

....and this for AL

=LET(f,FILTER($D$3:$O$10,$D$2:$O$2=TODAY()),IFERROR(ROWS(FILTER(f,f="AL")),0))

That worked great thank you very much for the assistance, much appreciated.