Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a link source. | Excel Worksheet Functions | |||
Finding duplicate data in a worksheet | Excel Discussion (Misc queries) | |||
Finding Asymptotes from a set of data in Excel | Excel Worksheet Functions | |||
Finding Asymptotes from a set of data in Excel | Excel Discussion (Misc queries) | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) |