COUNTIFS with weekday and timeframe

New Contributor



i am currently working on a sheet which has to calculate a certain no. of customers and revenue in a specific daytime and on a specific weekday and need a little help:


Specifically i want to calculate:

  • amount of customers on a friday in times between 10:00 AM and 12:00 PM
  • total revenue on a friday in times between 10:00 AM and 12:00 PM

Source example:

Cashier nametransaction no.Date First nameLast nameWeekdayTimeRevenue


Freitag is Friday in german btw.

In my understanding my function should look a little like this:



I think i may have an completely wrong approach.


I'd be grateful for any help offered.



8 Replies






@Hans Vogelaar 


Vielen Dank, leider gibt er mir nun eine "0" aus....




Irgendetwas falsch?


In your first post, the day of the week was in column G and the time in column H so it should have been



@Hans Vogelaar 


yea, i simplified the table to not fill up the post with unnecessary information.


the source table is called "Source" and is structured as followed:

VinothekKA2200083019.08.2022  BarverkaufGebuchtFreitag15:52:5319,50Vinothek1000127587


any clues why it tells "0"?


Legacy solution with Ctrl+Shift+Enter array:



Sum of revenue:


365 solution with FILTER:



sum of revenue




Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

best response confirmed by glitchone (New Contributor)

@Hans Vogelaar 

Thank you for sending the file by PM. The values in column I look like times, and they are formatted as times, but they are text values. You can do the following to convert them to real times:

Select column I.

On the Data tab of the ribbon, click Text to Columns.

Without changing any settings, click Finish.

I'll send the file back by PM.

Thank you so so much!

I didn't expect this to be reason why its not working!

Thanks also to @Patrick2788