Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
cj21
 
Posts: n/a
Default Adding easy


I have a list of products and corresponding values as follows:

Product Value
01 10
01 12
01 16
02 41
02 17
03 4
03 5

I want a formula that adds up the values for each cattogry. In
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=512664

 
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
Easy question? Page numbers ATC Excel Discussion (Misc queries) 1 February 1st 06 04:27 AM
adding vertical bars to an embedded chart using VBA Wazooli Excel Discussion (Misc queries) 0 November 15th 05 05:47 PM
help neede with adding times rvnwdr Excel Discussion (Misc queries) 1 June 17th 05 02:15 PM
problem adding rvnwdr Excel Discussion (Misc queries) 2 June 8th 05 06:36 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM


All times are GMT +1. The time now is 02:44 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"