Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
david72
 
Posts: n/a
Default summing data


Hi

I have a spreadsheet that will have the following data:

column A Column B

AG 10
BRK 20
CH 30
AG 50
AG 40
BRK 15
BRK 70


How do I get the above to be summed on the same spreadsheet like below
eg

column A column B

AG 100
BRK 105
CH 30

Thanks for any help on this mattter


--
david72
------------------------------------------------------------------------
david72's Profile: http://www.excelforum.com/member.php...fo&userid=7980
View this thread: http://www.excelforum.com/showthread...hreadid=542755

 
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
Pull data from another sheet based on certain criteria steve_sr2 Excel Discussion (Misc queries) 1 February 23rd 06 10:08 AM
Summing Up Data Based on Codes addie Excel Worksheet Functions 2 February 17th 06 11:09 PM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 12:45 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 09:08 AM.

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"