Count If statement and moving date

[RMJ]

Hello,
Hope you are all doing well.
My question today - I'm using a countif statement to determine how many folks will be working a specific skill on the current date. This total is than copied into another spreadsheet to show management the total number of people will be working the queue as the start of the day; but for the example the total is shown in another cell on the same tab. Please see example:

ID	1st Name	Surname	Date	Date	Date	Date	Date	Date	Date
			20-Jul​	21-Jul​	22-Jul​	23-Jul​	24-Jul​	29-Jul​	30-Jul​
u234987	John	Nathers	LA	LA	LA	LA			LA
a569254	Susan	Porter		LA		LA	LA	LA
davma00	Nahalia	Simms	LA	LA		LA		LA
u874139	Taylor	Jones			LA	LA	LA		LA
	2​

The formula in B8 is =COUNTIF(D3:D6,"=LA")

I hide the previous day's column, so for instance tomorrow, the spreadsheet will look like; but the data from previous days is only hidden:

ID	1st Name	Surname	Date
			30-Jul​
u234987	John	Nathers	LA
a569254	Susan	Porter
davma00	Nahalia	Simms
u874139	Taylor	Jones	LA
	2​

I tried using the formula of: =IF(B9=TODAY(),COUNTA(D3:XX6),"=LA"); but that gave me a total of 17 ( the total # that LA appears from column D through column XX)
Next I tried the formula of: =LOOKUP(B9,D:J), that yielded 44042; and I tried to format to have it show as a total for the current day, not successful

I'm trying to automate the spreadsheet so when it is determined who will work the LA queue for current day, cell B8 populates with the final count.

I hope it makes sense what I'm trying to do.
Thank you in advance for your help & guidance.
RMJ

 

[Toadstool]

Hi RMJ,

Try
=SUMPRODUCT(($D$3:$J$6="LA")*(--$D$2:$J$2=TODAY()))

 

[RMJ]

Hi RMJ,

Try
=SUMPRODUCT(($D$3:$J$6="LA")*(--$D$2:$J$2=TODAY()))

Thank you very much. That worked.
I really appreciate your help & guidance.