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.
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.
- Thank you so so much!
I didn't expect this to be reason why its not working!
Thanks also to Patrick2788