Counting data from another sheet:
Need instances of Class , if,
Date is >= Start date,
Date is <= End date,
Class needs to ="Webinar: AGM", "Webinar: Hybrid", "Webinar: ToolBox", or Webinar: Objections"
Columns = {Class} and {Date2}
Cell References= [Start Date]1 and [End Date]1
Formula says invalid operation.
=COUNTIFS({Class}, {,Date2}, >=[Start Date]1, {Date2}, <=[End Date]1, OR(@cell = "Webinar: AGM", @cell = "Webinar: Hybrid", @cell = "Webinar: ToolBox", @cell = "Webinar: Objections"))
Start and end date part works fine in other formulas. I think it's counting the individual class names that I cant get right.
