SUM
 

Example Spreadhseet

1 2 3 4

12 42 45 3
12 78 78 0
12 1234 2345 1111
13 3 5 2
14 1 6 5
14 2 2 4


Here is a sample of my sheet; in column 1 are policy lists sorted
numerically. In column 2 there are a lists of actual prices, and column 3
contains standar prices. Column 4 contains the difference between column 2
and 3. As you can see from column 1 there are several policies that have
duplicates.

I'm looking for a way to group the duplicates in column 1 to get the sum of
the differences in column 4?

--
Kevin

SUM
 

One way is to use Data, Subtotals. Select the data range first including
column headers which you should add if you don't have them.

For each change in the first column you should sum the fourth (in your
example).

--
Jim
"kevin2222222" wrote in message
...
| Example Spreadhseet
|
| 1 2 3 4
|
| 12 42 45 3
| 12 78 78 0
| 12 1234 2345 1111
| 13 3 5 2
| 14 1 6 5
| 14 2 2 4
|
|
| Here is a sample of my sheet; in column 1 are policy lists sorted
| numerically. In column 2 there are a lists of actual prices, and column 3
| contains standar prices. Column 4 contains the difference between column
2
| and 3. As you can see from column 1 there are several policies that have
| duplicates.
|
| I'm looking for a way to group the duplicates in column 1 to get the sum
of
| the differences in column 4?
|
| --
| Kevin

SUM
 

Try this:

Sum of difference for policy #12:

=SUMPRODUCT(--(A2:A7=12),C2:C7-B2:B7)

--
Biff
Microsoft Excel MVP


"kevin2222222" wrote in message
...
Example Spreadhseet

1 2 3 4

12 42 45 3
12 78 78 0
12 1234 2345 1111
13 3 5 2
14 1 6 5
14 2 2 4


Here is a sample of my sheet; in column 1 are policy lists sorted
numerically. In column 2 there are a lists of actual prices, and column 3
contains standar prices. Column 4 contains the difference between column
2
and 3. As you can see from column 1 there are several policies that have
duplicates.

I'm looking for a way to group the duplicates in column 1 to get the sum
of
the differences in column 4?

--
Kevin