| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing rows based on other column values | Excel Worksheet Functions | |||
| Summing values, x rows deep, depending on a criterion | Excel Worksheet Functions | |||
| Summing unique values | Excel Worksheet Functions | |||
| Summing Unique data values | Excel Worksheet Functions | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
Linear Mode
