Hi all,
Hope everyone is doing well.
I've tried searching for this solution but it seems more people need to omit blank cells, where I need to count them (and I am having trouble trying to word exactly what I need )
Here is the scenario:
I have a pivot table, in the rows I have names, and in the columns I have the day of the week (Sept 1-19 for example today). In those columns there are hours. I need to be able to count how many blank cells up until the report date to share how many days there have been no shows. So for example, if they didn't show up from the 13th-18th, I need a formula that would spit out how many days that is.
I've used =COUNTBLANK(XLOOKUP($A$2,$C$25:$T$25,$C26:$T26)) and it is able to tell me that the date in question is blank, but I can't figure out how to make it count the previous blank cells if there are any.
($A$2 is the date, C-T date ranges and data)
I hope this makes sense because as I said, I struggle to articulate what I need.
Any help is greatly appreciated.
Hope everyone is doing well.
I've tried searching for this solution but it seems more people need to omit blank cells, where I need to count them (and I am having trouble trying to word exactly what I need )
Here is the scenario:
I have a pivot table, in the rows I have names, and in the columns I have the day of the week (Sept 1-19 for example today). In those columns there are hours. I need to be able to count how many blank cells up until the report date to share how many days there have been no shows. So for example, if they didn't show up from the 13th-18th, I need a formula that would spit out how many days that is.
I've used =COUNTBLANK(XLOOKUP($A$2,$C$25:$T$25,$C26:$T26)) and it is able to tell me that the date in question is blank, but I can't figure out how to make it count the previous blank cells if there are any.
($A$2 is the date, C-T date ranges and data)
I hope this makes sense because as I said, I struggle to articulate what I need.
Any help is greatly appreciated.