Thread: CountIF
View Single Post
 
Old 08-23-2022, 10:36 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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