View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cathy Landry Cathy Landry is offline
external usenet poster
 
Posts: 37
Default 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