NBVAL on variable range
Solved
Hello everyone
I need your help because I can't figure out how to solve my problem.
Basically, I have a schedule.
People are listed in rows and dates in columns.
If there is an "X", it means the person is working.
I want to count the number of working days per person from the beginning of May until today (A1), so my range will expand by one additional column every day.
Names of people from B3 to B10
Dates from 01/05/2022 to 30/05/2022 starting at C2.
Thank you in advance, hoping a solution exists.
Thanks everyone
I need your help because I can't figure out how to solve my problem.
Basically, I have a schedule.
People are listed in rows and dates in columns.
If there is an "X", it means the person is working.
I want to count the number of working days per person from the beginning of May until today (A1), so my range will expand by one additional column every day.
Names of people from B3 to B10
Dates from 01/05/2022 to 30/05/2022 starting at C2.
Thank you in advance, hoping a solution exists.
Thanks everyone
3 answers
-
ContributorHello
A little example in the file
The formula
=COUNTIFS($C$2:$AG$2;"<="&$A$1;$C8:$AG8;"X")
A1 = TODAY()
C2:G2 the dates
C8:AG8 the row with the Xs
https://www.cjoint.com/c/LEmjWfqbHB4
-
Hello,
you do a =COUNTIF(B4:B35,"x")
so from B4 to B35 because there are 31 days in the month.
Best regards -
Thank you very much PHILOU, that's exactly what I needed.
Thank you for the quick response
Thank you for the clarity
