Seeking help to sum up certain data

[abberyfarm]

Hi,

I have data like this:

Excel Workbook
	A	B	C	D	E	F
1	Vehicle	Start Date	Start Time	Stop Date	Distance	Total Distance on same date
2	10D14499	04/01/2011	08:01:08	04/01/2011	9	9
3	10D14499	04/01/2011	17:46:34	04/01/2011	10	19
4	10D14499	05/01/2011	08:02:06	05/01/2011	9	9
5	10D14499	05/01/2011	17:31:59	05/01/2011	5	14
6	10D14499	06/01/2011	08:16:25	06/01/2011	9	9
7	10D14499	06/01/2011	13:56:04	06/01/2011	3	12
8	10D14499	06/01/2011	15:30:12	06/01/2011	10	22
9	10D14499	06/01/2011	17:06:48	06/01/2011	2	24
10	10D14499	06/01/2011	17:20:08	06/01/2011	2	26
11	10D14499	07/01/2011	08:12:49	07/01/2011	9	9
12	10D14499	07/01/2011	16:58:44	07/01/2011	10	19
13	10D14499	08/01/2011	13:07:31	08/01/2011	2	2
14	10D14499	08/01/2011	13:16:24	08/01/2011	1	3
15	10D14499	08/01/2011	14:22:34	08/01/2011	3	6
Sheet1

Would anybody know how I could sum up the total distance travelled on the same day only?

You see in Column F the distances are summed to a total distance travelled at that point given it is the same date.

I would appreciate any help.

Thank you

John

 

[baitmaster]

Depends on which version of Excel you are using
XL03 or earlier, you'll need SUMPRODUCT or an array formula
XL07 or later you can use SUMIFS

 

[Jonmo1]

Assuming:
1. The dates are Sorted Ascending
2. The drive times start and end on the same day.

In F2 and filled down

=SUMIF(B$2:B2,B2,E$2:E2)

 

[baitmaster]

****, where did I get multiple conditions from?! I'm gonna stop giving advice today if thats the quality of it

 

[Jonmo1]

Don't give up..
Helping others is the best way to help yourself..

****, where did I get multiple conditions from?! I'm gonna stop giving advice today if thats the quality of it