View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve M Steve M is offline
external usenet poster
 
Posts: 19
Default Finding descrete valuse

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%