CountIF

08-23-2022, 10:36 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If / countif	Kiwi971	Excel	1	06-03-2021 04:30 AM
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 12:29 PM.