Comparing data in mult rows then summing unique values

[Cathy Landry]

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

 

[Alan]

With the data in columns A2150,
=SUMPRODUCT(--($A$2:$A$150=A2),--($B$2:$B$150=B2),--($C$2:$C$150=C2),--($D$2:$D$150))
Regards,
Alan.

 

[Cathy Landry]

Hi Alan,

That works!! Thank you

With the data in columns A2150,
=SUMPRODUCT(--($A$2:$A$150=A2),--($B$2:$B$150=B2),--($C$2:$C$150=C2),--($D$2:$D$150))
Regards,
Alan.