View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich D Rich D is offline
external usenet poster
 
Posts: 63
Default Adding certain numbers based on...

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