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...

Formulas and Functions

mtarler
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

mtarler

Silver Contributor

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

Phishdawg

Brass Contributor

May 04, 2023

mtarler

Actually had a few typos, which I've corrected.

Formula works as advertised.

Thank you!

Forum Discussion

Number of Tickets Per Hour of Given Day