Forum Discussion
COUNTIFS with weekday and timeframe
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.
Vielen Dank, leider gibt er mir nun eine "0" aus....
=ZÄHLENWENNS(Source!H2:H3155;"Freitag";Source!I2:I3155;">="&ZEIT(10;0;0);Source!I2:I3155;"<="&ZEIT(12;0;0))
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
=ZÄHLENWENNS(G2:G3000;"Freitag";H2:H3000;">="&ZEIT(10;0;0);H2:H3000;"<="&ZEIT(12;0;0))
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:
A B C D E F G H I J K L M Kassenname Belegnummer Datum Vorname Anrede Name Status Wochentag Zeit Betrag Verkäufer Kundennummer Kassenbuchnr. Vinothek KA22000830 19.08.2022 Barverkauf Gebucht Freitag 15:52:53 19,50 Vinothek 10001 27587 any clues why it tells "0"?
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.
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.