# Seeking help to sum up certain data

#### abberyfarm

##### Well-known Member
Hi,

I have data like this:

Excel Workbook
ABCDEF
1VehicleStart DateStart TimeStop DateDistanceTotal Distance on same date
210D1449904/01/201108:01:0804/01/201199
310D1449904/01/201117:46:3404/01/20111019
410D1449905/01/201108:02:0605/01/201199
510D1449905/01/201117:31:5905/01/2011514
610D1449906/01/201108:16:2506/01/201199
710D1449906/01/201113:56:0406/01/2011312
810D1449906/01/201115:30:1206/01/20111022
910D1449906/01/201117:06:4806/01/2011224
1010D1449906/01/201117:20:0806/01/2011226
1110D1449907/01/201108:12:4907/01/201199
1210D1449907/01/201116:58:4407/01/20111019
1310D1449908/01/201113:07:3108/01/201122
1410D1449908/01/201113:16:2408/01/201113
1510D1449908/01/201114:22:3408/01/201136
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

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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

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)

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

Don't give up..

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

Replies
13
Views
565
Replies
2
Views
200
Replies
2
Views
248
Replies
6
Views
322
Replies
1
Views
226

1,203,317
Messages
6,054,711
Members
444,742
Latest member
jmartin9247

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back