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.
=COUNTIFS(G2:G3000;"Freitag";I2:I3000;">="&TIME(10;0;0);I2:I3000;"<="&TIME(12;0;0))
=ZÄHLENWENNS(G2:G3000;"Freitag";I2:I3000;">="&ZEIT(10;0;0);I2:I3000;"<="&ZEIT(12;0;0))
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.