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

Comparing data in mult rows then summing unique values
 

With the data in columns A2:D150,
=SUMPRODUCT(--($A$2:$A$150=A2),--($B$2:$B$150=B2),--($C$2:$C$150=C2),--($D$2:$D$150))
Regards,
Alan.
"Cathy Landry" wrote in message
...
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

Comparing data in mult rows then summing unique values
 

Hi Alan,

That works!! Thank you :)

"Alan" wrote:

With the data in columns A2:D150,
=SUMPRODUCT(--($A$2:$A$150=A2),--($B$2:$B$150=B2),--($C$2:$C$150=C2),--($D$2:$D$150))
Regards,
Alan.
"Cathy Landry" wrote in message
...
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