Need help with COUNTIF + COUNTIFS formula

Debrastus

New member
Joined
Nov 22, 2021
Messages
3
Reaction score
0
Points
0
Location
Oliver BC
Excel Version(s)
Excel 365 for Mac
In the attached file (Tour Bookings) I am trying to count the number of tours booked Directly or Indirectly per year. I have entered the formula to count the number of tours booked in each year but I cannot figure out how to break this down further by counting the number booked Directly or Indirectly. I tried combining the COUNTIF formula but it's not working. Any help will be greatly appreciated. Thanks!
 

Attachments

  • Tour Bookings.xlsx
    13.5 KB · Views: 5
Try

=COUNTIFS(dates,">="&DATE($E4,1,1),dates,"<="&DATE($E4,12,31),OFFSET(dates,0,2),G$3)
 
This is better IMO

COUNTIFS(dates,">="&DATE($E4,1,1),dates,"<="&DATE($E4,12,31),INDEX(Xola_TZ,0,3),G$3)
 
Thank you so much Bob for the quick turnaround! That works like a charm! :yo:
 
Back
Top