if one colum has State names in it and one has the total miles how can you get the total of each states miles

asked 2016-11-16 14:34:12 -0600

JoLanna gravatar image

Here is sample DATE PROV OD IN OD OUT TRAVELLED
20-Sep NM 618,807 619,240 433
20-Sep TX 619,240 619,418 178
20-Sep OK 619,418 619,778 360
20-Sep MO 619,778 620,068 290
20-Sep IL 620,068 620,209 141
21-Sep IN 620,209 620,334 125
21-Sep KY 620,334 620,654 320
21-Sep TN 620,654 621,133 479
22-Sep AR 621,133 621,420 287
23-Sep OK 621,420 621,754 334
23-Sep TX 621,754 621,932 178
24-Sep NM 621,932 622,345 413

edit retag flag offensive close merge delete