Ron:
Thanks for the input. Yes it does help and meets my needs. Don't know why
I didn't think of it myself.
Thanks again
Steve


"Ron Coderre" wrote:

Hi, Steve
I'm thinking that a Pivot Table is the easiest way to summarize the Col_A
values.

You'll need column headings to do that.
A1: Category
B1: Pct

Try this:

From the Excel main menu:
<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the Category field here
DATA: Drag the Pct field here
If it doesn't list as Sum of Pct...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table...and you're done.

That will list each distinct Category and the sum of corresponding Pcts.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Steve M" wrote:

I have a spreadsheet with a column containing 192 cells (column A below).
Some of the cells contain the same value. For each cell there is a related
cell in the same row (Column B below). As I change other values in my
spreadsheet the 192 cells (Column A)may change. I would like to sum the
values in the related cells (column B)for each of the 192 cells that contain
the same value. I tried to use the "small" function in conjunction with the
"sumif" but the "small" function does not differenciate between repeat
values.

Example of the problem
A B
1 17.5 15%
2 17.5 10%
3 18 5%
4 19 20%
5 19 20%
6 19 30%

I would like to have the following results:

7 17.5 25%
8 18 5%
9 19 70%