choose the daily results from a month and only for only one truck.

[Jurgen Smits]

Hello,

I want to choose the daily results from a month and only for only one truck.

I mark yellow for to choose the truck numbre and also for the month. For me the tricky thing is that there are different number of days. 02:28-29 03:31,...

I tried different things, I'm stuck.

Can someone help me?

Jürgen

 

[Hui]

Change the Numbers in Results A7:A37 to be Numbers 1, 2, 3 etc

B7: =SUMPRODUCT((daily!$B$5:$GQ$309)*(daily!$A$5:$A$309=$B$1+$A7-1)*(daily!$B$2:$GQ$2=B$4)*(daily!$B$3:$GQ$3=B$5)*(daily!$B$4:$GQ$4=B$6))

Copy across and down

 

[xlstime]

Hi Jurgen,

Please see if this is ok

Hello,

I want to choose the daily results from a month and only for only one truck.

I mark yellow for to choose the truck numbre and also for the month. For me the tricky thing is that there are different number of days. 02:28-29 03:31,...

I tried different things, I'm stuck.

Can someone help me?

Jürgen