Results 1 to 4 of 4

Thread: Need help with COUNTIF + COUNTIFS formula

  1. #1
    Neophyte Debrastus's Avatar
    Join Date
    Nov 2021
    Location
    Oliver BC
    Posts
    3
    Articles
    0
    Excel Version
    Excel 365 for Mac

    Need help with COUNTIF + COUNTIFS formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,889
    Articles
    0
    Excel Version
    O365
    Try

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

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,889
    Articles
    0
    Excel Version
    O365
    This is better IMO

    COUNTIFS(dates,">="&DATE($E4,1,1),dates,"<="&DATE($E4,12,31),INDEX(Xola_TZ,0,3),G$3)

  4. #4
    Neophyte Debrastus's Avatar
    Join Date
    Nov 2021
    Location
    Oliver BC
    Posts
    3
    Articles
    0
    Excel Version
    Excel 365 for Mac
    Thank you so much Bob for the quick turnaround! That works like a charm!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •