Help with counting values off column from non-table cell range

[JEH105]

Hello!

Using the sample table below, which formula can I use to pull the count of "Available" cells in this text range (not a table), but only for the specific column which matches today's date? I've tried a few variations of COUNTIF with HLOOKUP, but it's not working for me.

11/6/2023	11/7/2023	11/8/2023	11/9/2023	11/10/2023
Available	Available	U	Available	Available
Available	Available	Available	8	Available
U	Available	Available	Available	Available
8	Available	Available	Available	U

Important: I can't make this range of cells into a table because all cells are return values from formulas in place.

I appreciate any help!

 

[Fluff]

How about

=COUNTIFS(INDEX(A:E,0,XMATCH(TODAY(),A1:E1)),"Available")

 

[JEH105]

How about

=COUNTIFS(INDEX(A:E,0,XMATCH(TODAY(),A1:E1)),"Available")

I tried this, but got "#N/A" as a result instead of the count. Not sure if this is because all the cells have formulas.

 

[JEH105]

I tried this, but got "#N/A" as a result instead of the count. Not sure if this is because all the cells have formulas.

Cancel this, it worked. I just had to edit the specific range. Here's what worked:

=COUNTIFS(INDEX(J6:N9,0,XMATCH(TODAY(),J5:N5)),"Available")

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.