Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2022, 01:47 PM
Loopylee2020 Loopylee2020 is offline CountIF Windows 10 CountIF Office 2021
Novice
CountIF
 
Join Date: Aug 2022
Posts: 3
Loopylee2020 is on a distinguished road
Default CountIF

hi,
im after a count if that brings back the CL's from the third column after todays date

WorkDate FINISHTIME Shift
1-Apr-2022 22:00:00 L
2-Apr-2022 00:00:00 -
3-Apr-2022 00:00:00 -
4-Apr-2022 00:00:00 H
5-Apr-2022 00:00:00 H
6-Apr-2022 00:00:00 H
7-Apr-2022 00:00:00 H
8-Apr-2022 00:00:00 H
9-Apr-2022 00:00:00 -
10-Apr-2022 00:00:00 HS
11-Apr-2022 14:00:00 D
12-Apr-2022 22:00:00 L
13-Apr-2022 22:00:00 L
14-Apr-2022 22:00:00 L
15-Apr-2022 00:00:00 -
16-Apr-2022 00:00:00 -
17-Apr-2022 00:00:00 -
18-Apr-2022 17:00:00 S
19-Apr-2022 00:00:00 CD
20-Apr-2022 14:00:00 E
21-Apr-2022 14:00:00 E
22-Apr-2022 00:00:00 W
23-Apr-2022 00:00:00 -
24-Apr-2022 00:00:00 -
25-Apr-2022 22:00:00 L
26-Apr-2022 22:00:00 L
27-Apr-2022 22:00:00 L
28-Apr-2022 22:00:00 L
29-Apr-2022 22:00:00 L
30-Apr-2022 00:00:00 -
1-May-2022 00:00:00 -
2-May-2022 00:00:00 -
3-May-2022 14:00:00 E
4-May-2022 14:00:00 E
5-May-2022 14:00:00 E
6-May-2022 14:00:00 E
7-May-2022 00:00:00 -
8-May-2022 17:00:00 SL
9-May-2022 00:00:00 W
10-May-2022 22:00:00 L
11-May-2022 22:00:00 L
12-May-2022 22:00:00 L
13-May-2022 00:00:00 CL
14-May-2022 00:00:00 -
15-May-2022 00:00:00 -
16-May-2022 14:00:00 E
17-May-2022 14:00:00 E
18-May-2022 14:00:00 E
19-May-2022 14:00:00 E
20-May-2022 14:00:00 E
21-May-2022 00:00:00 -
22-May-2022 00:00:00 -
23-May-2022 22:00:00 L
24-May-2022 22:00:00 L
25-May-2022 22:00:00 L
26-May-2022 22:00:00 L
27-May-2022 22:00:00 L
28-May-2022 00:00:00 -
29-May-2022 00:00:00 -
30-May-2022 14:00:00 D
31-May-2022 14:00:00 D
1-Jun-2022 00:00:00 W
2-Jun-2022 00:00:00 -
3-Jun-2022 00:00:00 -
4-Jun-2022 00:00:00 -
5-Jun-2022 00:00:00 -
6-Jun-2022 00:00:00 H
7-Jun-2022 00:00:00 H
8-Jun-2022 00:00:00 H
9-Jun-2022 00:00:00 H
10-Jun-2022 00:00:00 H
11-Jun-2022 00:00:00 -
12-Jun-2022 00:00:00 HS
13-Jun-2022 14:00:00 E
14-Jun-2022 14:00:00 E
15-Jun-2022 14:00:00 E
16-Jun-2022 00:00:00 CD
17-Jun-2022 14:00:00 E
18-Jun-2022 00:00:00 -
19-Jun-2022 17:00:00 SL
20-Jun-2022 22:00:00 L
21-Jun-2022 22:00:00 L
22-Jun-2022 22:00:00 L
23-Jun-2022 22:00:00 L
24-Jun-2022 22:00:00 L
25-Jun-2022 00:00:00 -
26-Jun-2022 17:00:00 SE
27-Jun-2022 00:00:00 W
28-Jun-2022 14:00:00 E
29-Jun-2022 14:00:00 E
30-Jun-2022 14:00:00 E
1-Jul-2022 14:00:00 E
2-Jul-2022 00:00:00 -
3-Jul-2022 00:00:00 -
4-Jul-2022 22:00:00 L
5-Jul-2022 00:00:00 CL
6-Jul-2022 22:00:00 L
7-Jul-2022 22:00:00 L
8-Jul-2022 22:00:00 L
9-Jul-2022 00:00:00 -
10-Jul-2022 17:00:00 SE
11-Jul-2022 14:00:00 E
12-Jul-2022 14:00:00 E
13-Jul-2022 14:00:00 E
14-Jul-2022 14:00:00 E
15-Jul-2022 00:00:00 W
16-Jul-2022 00:00:00 -
17-Jul-2022 00:00:00 -
18-Jul-2022 00:00:00 H
19-Jul-2022 00:00:00 H
20-Jul-2022 00:00:00 H
21-Jul-2022 00:00:00 H
22-Jul-2022 00:00:00 H
23-Jul-2022 00:00:00 -
24-Jul-2022 00:00:00 HS
25-Jul-2022 14:00:00 E
26-Jul-2022 14:00:00 E
27-Jul-2022 14:00:00 E
28-Jul-2022 14:00:00 E
29-Jul-2022 14:00:00 E
30-Jul-2022 00:00:00 -
31-Jul-2022 17:00:00 SL
1-Aug-2022 22:00:00 L
2-Aug-2022 00:00:00 W
3-Aug-2022 22:00:00 L
4-Aug-2022 22:00:00 L
5-Aug-2022 22:00:00 L
6-Aug-2022 00:00:00 -
7-Aug-2022 17:00:00 SE
8-Aug-2022 14:00:00 E
9-Aug-2022 14:00:00 E
10-Aug-2022 14:00:00 E
11-Aug-2022 00:00:00 W
12-Aug-2022 00:00:00 CD
13-Aug-2022 00:00:00 -
14-Aug-2022 00:00:00 -
15-Aug-2022 22:00:00 L
16-Aug-2022 22:00:00 L
17-Aug-2022 22:00:00 L
18-Aug-2022 22:00:00 L
19-Aug-2022 22:00:00 L
20-Aug-2022 00:00:00 -
21-Aug-2022 00:00:00 -
22-Aug-2022 14:00:00 E
23-Aug-2022 14:00:00 E
24-Aug-2022 14:00:00 E
25-Aug-2022 14:00:00 E
26-Aug-2022 14:00:00 E
27-Aug-2022 00:00:00 -
28-Aug-2022 00:00:00 -
29-Aug-2022 17:00:00 S
30-Aug-2022 22:00:00 L
31-Aug-2022 00:00:00 CL
1-Sep-2022 00:00:00 W
2-Sep-2022 22:00:00 L
3-Sep-2022 00:00:00 -
4-Sep-2022 00:00:00 -
5-Sep-2022 14:00:00 E
6-Sep-2022 14:00:00 E
7-Sep-2022 14:00:00 E
8-Sep-2022 14:00:00 E
9-Sep-2022 14:00:00 E
10-Sep-2022 00:00:00 -
11-Sep-2022 17:00:00 SL
12-Sep-2022 00:00:00 W
13-Sep-2022 22:00:00 L
14-Sep-2022 22:00:00 L
15-Sep-2022 22:00:00 L
16-Sep-2022 22:00:00 L
17-Sep-2022 00:00:00 -
18-Sep-2022 00:00:00 -
19-Sep-2022 14:00:00 E
20-Sep-2022 14:00:00 E
21-Sep-2022 14:00:00 E
22-Sep-2022 14:00:00 E
23-Sep-2022 14:00:00 E
24-Sep-2022 00:00:00 -
25-Sep-2022 17:00:00 SL
26-Sep-2022 22:00:00 L
27-Sep-2022 00:00:00 W
28-Sep-2022 22:00:00 L
29-Sep-2022 22:00:00 L
30-Sep-2022 22:00:00 L
1-Oct-2022 00:00:00 -
2-Oct-2022 00:00:00 -
3-Oct-2022 14:00:00 E
4-Oct-2022 00:00:00 CD
5-Oct-2022 14:00:00 E
6-Oct-2022 14:00:00 E
7-Oct-2022 14:00:00 E
8-Oct-2022 00:00:00 -
9-Oct-2022 17:00:00 SL
10-Oct-2022 22:00:00 L
11-Oct-2022 22:00:00 L
12-Oct-2022 22:00:00 L
13-Oct-2022 22:00:00 L
14-Oct-2022 00:00:00 W
15-Oct-2022 00:00:00 -
16-Oct-2022 00:00:00 -
17-Oct-2022 00:00:00 H
18-Oct-2022 00:00:00 H
19-Oct-2022 00:00:00 H
20-Oct-2022 00:00:00 H
21-Oct-2022 00:00:00 H
22-Oct-2022 00:00:00 -
23-Oct-2022 00:00:00 HS
24-Oct-2022 22:00:00 L
25-Oct-2022 22:00:00 L
26-Oct-2022 22:00:00 L
27-Oct-2022 22:00:00 L
28-Oct-2022 00:00:00 CL
29-Oct-2022 00:00:00 -
30-Oct-2022 17:00:00 SE
31-Oct-2022 14:00:00 E
1-Nov-2022 14:00:00 E
2-Nov-2022 00:00:00 W
3-Nov-2022 14:00:00 E
4-Nov-2022 14:00:00 E
5-Nov-2022 00:00:00 -
6-Nov-2022 00:00:00 -
7-Nov-2022 22:00:00 L
8-Nov-2022 22:00:00 L
9-Nov-2022 22:00:00 L
10-Nov-2022 22:00:00 L
11-Nov-2022 22:00:00 L
12-Nov-2022 00:00:00 -
13-Nov-2022 00:00:00 -
14-Nov-2022 00:00:00 CD
15-Nov-2022 14:00:00 E
16-Nov-2022 14:00:00 E
17-Nov-2022 14:00:00 E
18-Nov-2022 14:00:00 E
19-Nov-2022 00:00:00 -
20-Nov-2022 00:00:00 -
21-Nov-2022 22:00:00 L
22-Nov-2022 22:00:00 L
23-Nov-2022 22:00:00 L
24-Nov-2022 22:00:00 L
25-Nov-2022 22:00:00 L
26-Nov-2022 00:00:00 -
27-Nov-2022 17:00:00 SE
28-Nov-2022 14:00:00 E
29-Nov-2022 14:00:00 E
30-Nov-2022 14:00:00 E
1-Dec-2022 14:00:00 E
2-Dec-2022 00:00:00 W
3-Dec-2022 00:00:00 -
4-Dec-2022 00:00:00 -
5-Dec-2022 22:00:00 L
6-Dec-2022 00:00:00 CL
7-Dec-2022 22:00:00 L
8-Dec-2022 22:00:00 L
9-Dec-2022 22:00:00 L
10-Dec-2022 00:00:00 -
11-Dec-2022 00:00:00 -
12-Dec-2022 14:00:00 E
13-Dec-2022 14:00:00 E
14-Dec-2022 14:00:00 E
15-Dec-2022 14:00:00 E
16-Dec-2022 14:00:00 E
17-Dec-2022 00:00:00 -
18-Dec-2022 17:00:00 SL
19-Dec-2022 22:00:00 L
20-Dec-2022 00:00:00 W
21-Dec-2022 22:00:00 L
22-Dec-2022 22:00:00 L
23-Dec-2022 22:00:00 L
24-Dec-2022 00:00:00 -
25-Dec-2022 00:00:00 -
26-Dec-2022 00:00:00 -
27-Dec-2022 00:00:00 -
28-Dec-2022 14:00:00 E
29-Dec-2022 14:00:00 E
30-Dec-2022 14:00:00 E
31-Dec-2022 00:00:00 -
1-Jan-2023 00:00:00 -
2-Jan-2023 00:00:00 -
3-Jan-2023 22:00:00 L
4-Jan-2023 22:00:00 L
5-Jan-2023 22:00:00 L
6-Jan-2023 00:00:00 CL
7-Jan-2023 00:00:00 -
8-Jan-2023 17:00:00 SE
9-Jan-2023 14:00:00 E
10-Jan-2023 00:00:00 W
11-Jan-2023 14:00:00 E
12-Jan-2023 14:00:00 E
13-Jan-2023 14:00:00 E
14-Jan-2023 00:00:00 -
15-Jan-2023 00:00:00 -
16-Jan-2023 22:00:00 L
17-Jan-2023 22:00:00 L
18-Jan-2023 00:00:00 H
19-Jan-2023 22:00:00 L
20-Jan-2023 22:00:00 L
21-Jan-2023 00:00:00 -
22-Jan-2023 17:00:00 SE
23-Jan-2023 00:00:00 CD
24-Jan-2023 14:00:00 E
25-Jan-2023 14:00:00 E
26-Jan-2023 14:00:00 E
27-Jan-2023 00:00:00 W
28-Jan-2023 00:00:00 -
29-Jan-2023 00:00:00 -
30-Jan-2023 22:00:00 L
31-Jan-2023 22:00:00 L
1-Feb-2023 22:00:00 L
2-Feb-2023 00:00:00 H
3-Feb-2023 22:00:00 L
4-Feb-2023 00:00:00 -


5-Feb-2023 00:00:00 -
6-Feb-2023 14:00:00 E
7-Feb-2023 14:00:00 E
8-Feb-2023 14:00:00 E
9-Feb-2023 14:00:00 E
10-Feb-2023 14:00:00 E
11-Feb-2023 00:00:00 -
12-Feb-2023 17:00:00 SL
13-Feb-2023 22:00:00 L
14-Feb-2023 00:00:00 CL
15-Feb-2023 22:00:00 L
16-Feb-2023 22:00:00 L
17-Feb-2023 00:00:00 W
18-Feb-2023 00:00:00 -
19-Feb-2023 00:00:00 -
20-Feb-2023 00:00:00 H
21-Feb-2023 00:00:00 H
22-Feb-2023 00:00:00 H
23-Feb-2023 00:00:00 H
24-Feb-2023 00:00:00 H
25-Feb-2023 00:00:00 -
26-Feb-2023 00:00:00 HS
27-Feb-2023 22:00:00 L
28-Feb-2023 22:00:00 L
1-Mar-2023 22:00:00 L
2-Mar-2023 22:00:00 L
3-Mar-2023 22:00:00 L
4-Mar-2023 00:00:00 -
5-Mar-2023 00:00:00 -
6-Mar-2023 14:00:00 E
7-Mar-2023 14:00:00 E
8-Mar-2023 14:00:00 E
9-Mar-2023 14:00:00 E
10-Mar-2023 00:00:00 H
11-Mar-2023 00:00:00 -
12-Mar-2023 00:00:00 -
13-Mar-2023 22:00:00 L
14-Mar-2023 22:00:00 L
15-Mar-2023 22:00:00 L
16-Mar-2023 22:00:00 L
17-Mar-2023 22:00:00 L
18-Mar-2023 00:00:00 -
19-Mar-2023 00:00:00 -
20-Mar-2023 00:00:00 CD
21-Mar-2023 14:00:00 E
22-Mar-2023 14:00:00 E
23-Mar-2023 14:00:00 E
24-Mar-2023 14:00:00 E
25-Mar-2023 00:00:00 -
26-Mar-2023 00:00:00 -
27-Mar-2023 22:00:00 L
28-Mar-2023 22:00:00 L
29-Mar-2023 22:00:00 L
30-Mar-2023 22:00:00 L
31-Mar-2023 22:00:00 L

Thanks

Regards
Lee Watson
Reply With Quote
  #2  
Old 08-23-2022, 10:36 PM
ArviLaanemets ArviLaanemets is offline CountIF Windows 8 CountIF Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Code:
=COUNTIFS(WorkDate,">" & TODAY(),Shift, "CL")
where Workdate will be "[Workdate]" and Shift will be "[Shift]" in case you define your table as Table,
or Workdate and Shift will be Dynamic Named Ranges you have defined,
or they will be dataranges like "A2:A100", "D2: D100".

Last edited by ArviLaanemets; 08-24-2022 at 04:50 AM.
Reply With Quote
  #3  
Old 08-23-2022, 11:15 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline CountIF Windows 7 64bit CountIF Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@loopy
In the future please post an Excel sheet. It's much easier than to have to create one ourselves ( no pics please). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If / countif Kiwi971 Excel 1 06-03-2021 04:30 AM
CountIF COUNTIF - A vs. AA??? SoMany Excel 4 01-01-2021 12:50 AM
Help with COUNTIF MaineLady Excel 1 05-24-2019 02:53 PM
CountIF Functions Alaska1 Excel 4 01-30-2015 09:59 AM
Countif hockeytown Excel 3 01-05-2013 08:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft