Counting Criteria under the Date today Only

Shinianne

New Member
Joined
Aug 6, 2018
Messages
24
Office Version
  1. 365
24DWYHV


Great day,

I'd like to ask for you kind assistance
Will it be possible to count the VL that falls under the date today?

if yes can you kindly help please thank you so much:confused:




[TABLE="width: 613"]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]18-Mar[/TD]
[TD]19-Mar[/TD]
[TD]20-Mar[/TD]
[TD]21-Mar[/TD]
[TD]22-Mar[/TD]
[TD]23-Mar[/TD]
[TD]24-Mar[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Schedule[/TD]
[TD]Region[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]VL[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]11PM-8AM[/TD]
[TD]AMER[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]11PM-8AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[TR]
[TD]3PM-12AM[/TD]
[TD]EMEA[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]3PM-12AM[/TD]
[TD]RD[/TD]
[TD]RD[/TD]
[/TR]
[/TABLE]
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Two options


Excel 2013/2016
ABCDEFGHIJK
118-Mar19-Mar20-Mar21-Mar22-Mar23-Mar24-Mar
2
3ScheduleRegionMondayTuesdayWednesdayThursdayFridaySaturdaySunday
411PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD2
511PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AMVLRDRD2
611PM-8AMAMER11PM-8AM11PM-8AMVLRDRD11PM-8AM11PM-8AM
711PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMRDRD11PM-8AM11PM-8AM
811PM-8AMAMER11PM-8AM11PM-8AM11PM-8AM11PM-8AM11PM-8AMRDRD
911PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMVL11PM-8AMVLRD
1011PM-8AMAMER11PM-8AM11PM-8AM11PM-8AMVL11PM-8AMRDRD
113PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
123PM-12AMEMEA3PM-12AM3PM-12AMRDRD3PM-12AM3PM-12AM3PM-12AM
133PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
143PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
153PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
163PM-12AMEMEA3PM-12AM3PM-12AM3PM-12AM3PM-12AM3PM-12AMRDRD
Recon-I
Cell Formulas
RangeFormula
K4=COUNTIF(INDEX(C4:I16,0,MATCH(TODAY(),C1:I1,0)),"VL")
K5=SUMPRODUCT((C4:I16="VL")*(C1:I1=TODAY()))
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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