LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
summing numbers based on 2nd column John K Excel Worksheet Functions 3 August 7th 06 06:22 PM
Adding adjacent numbers and resettiing when encountering 0 Midnight404 Excel Worksheet Functions 0 August 5th 05 01:03 PM
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA Master Excel Worksheet Functions 2 July 12th 05 05:03 PM
Adding numbers to current numbers mk Excel Worksheet Functions 2 May 16th 05 11:25 PM
Adding numbers in a column that have 3 decimal places KimberlyC Excel Worksheet Functions 4 April 24th 05 01:25 AM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"