Excelquestion35
Board Regular
- Joined
- Nov 29, 2021
- Messages
- 53
- Office Version
- 2016
- Platform
- Windows
Hi all,
Currently I am working on a heatmap with timestamps. For this I use a countifs formula.
The heatmap is based on the following data:
COUNTIFS formula:
Heatmap (WIP):
As you can see the count is done for every timestamp during a date, however it should be done only for that specific date. In case of 9-03-2022 it should only show a one at time stamp 16:15.
Any clue on what I am doing wrong?
Currently I am working on a heatmap with timestamps. For this I use a countifs formula.
The heatmap is based on the following data:
COUNTIFS formula:
Excel Formula:
=COUNTIFS('Time span per order'!$K:$K;"JA";'Time span per order'!$L:$L;">="&'Heatmap order release'!$A2;'Time span per order'!$L:$L;"<"&'Heatmap order release'!$A2+1;'Time span per order'!$M:$M;">="&'Heatmap order release'!B$1;'Time span per order'!$M:$M;"<"&'Heatmap order release'!B$1+1)Heatmap (WIP):
As you can see the count is done for every timestamp during a date, however it should be done only for that specific date. In case of 9-03-2022 it should only show a one at time stamp 16:15.
Any clue on what I am doing wrong?
