Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|