Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 2 columns of numbers. the first column contains phase numbers, the
second column contains amounts. I need to sum (add) all the numbers in the second column which correspond to a certain number (repeated several times) in the first column. 6.1 $15.05 4.2 $19.23 9.1 $42.00 6.1 $57.50 In the example, I need to add all the amounts for phase 6.1, in this case, equalling $72.55. Thanks for any help. Rich Rich D Armstrong Custom Homes Redmond |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
summing numbers based on 2nd column | Excel Worksheet Functions | |||
Adding adjacent numbers and resettiing when encountering 0 | Excel Worksheet Functions | |||
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
Adding numbers to current numbers | Excel Worksheet Functions | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions |