Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
May 04, 2023

Number of Tickets Per Hour of Given Day

Thanks to the wisdom of @mathetes I have almost got my puzzle solved. I now seek the number of 'Tickets' issued for each hour of the day represented in Column C. I currently have a formula that ha...
  • mtarler's avatar
    May 04, 2023

    Phishdawg I think it will be:

     

    =ROWS(FILTER(A2:A782330,
          (HOUR(DailyTransactionSht!D2:D782330)=C4)*
          (DailyTransactionSht!A2:A782330=$C$1)))

    where I assume C1 is the location of that date and C4 is the location of the hour

     

Resources