Count If statement and moving date

RMJ

New Member
Joined
Jul 28, 2020
Messages
10
Office Version
  1. 2010
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:

ID1st NameSurnameDateDateDateDateDateDateDate
20-Jul​
21-Jul​
22-Jul​
23-Jul​
24-Jul​
29-Jul​
30-Jul​
u234987JohnNathersLALALALALA
a569254SusanPorterLALALALA
davma00NahaliaSimmsLALALALA
u874139TaylorJonesLALALALA
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:

ID1st NameSurnameDate
30-Jul​
u234987JohnNathersLA
a569254SusanPorter
davma00NahaliaSimms
u874139TaylorJonesLA
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Hi RMJ,

Try
=SUMPRODUCT(($D$3:$J$6="LA")*(--$D$2:$J$2=TODAY()))
 
  • Like
Reactions: RMJ
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top