Comparing data in mult rows then summing unique values
Hello,
We currently have a mileage form with roughly 150 rows that we need to sum
total miles by unique loc/dept/modality.....
Example:
Loc Dept Modality Miles
611 960 600 10
611 940 600 10
611 960 600 10
611 950 300 10
760 940 300 10
653 940 380 10
Desired Results:
Loc Dept Modality Miles
611 960 600 20
611 940 600 10
611 950 300 10
760 940 300 10
653 940 380 10
Thank you in advance for any assistance :)
Cathy
|