Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Need formula to add cells with same group

I have a sheet 1 with two columns. Column A has a manufacturer name, Column
B has a number. Column A has the manufacturer names repeated multiple times
within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers
that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a
formula that will add all the numbers for each manufacturer. So, if Hp shows
up 15 times in column A, the formula will add only those numbers that match
column A and produce the total of the numbers added together for that
manufacturer.

Ex. Sheet 1: Column A, Column B

HP, 5.50
HP, 5.75
DF, 5.00
DF, 4.25

Sheet 2: end result Im looking for:
HP, 11.25
DF, 9.25
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default Need formula to add cells with same group

brantty wrote:
I have a sheet 1 with two columns. Column A has a manufacturer name, Column
B has a number. Column A has the manufacturer names repeated multiple times
within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers
that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a
formula that will add all the numbers for each manufacturer. So, if Hp shows
up 15 times in column A, the formula will add only those numbers that match
column A and produce the total of the numbers added together for that
manufacturer.

Ex. Sheet 1: Column A, Column B

HP, 5.50
HP, 5.75
DF, 5.00
DF, 4.25

Sheet 2: end result Im looking for:
HP, 11.25
DF, 9.25


SUMIF is your friend here. Per help SUMIF "Adds the cells specified by a
given criteria."

In Sheet2 B1 and fill down:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

where Sheet2 A1 = HP
A2 = DF
etc.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Need formula to add cells with same group



"smartin" wrote:

brantty wrote:
I have a sheet 1 with two columns. Column A has a manufacturer name, Column
B has a number. Column A has the manufacturer names repeated multiple times
within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers
that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a
formula that will add all the numbers for each manufacturer. So, if Hp shows
up 15 times in column A, the formula will add only those numbers that match
column A and produce the total of the numbers added together for that
manufacturer.

Ex. Sheet 1: Column A, Column B

HP, 5.50
HP, 5.75
DF, 5.00
DF, 4.25

Sheet 2: end result Im looking for:
HP, 11.25
DF, 9.25


SUMIF is your friend here. Per help SUMIF "Adds the cells specified by a
given criteria."

In Sheet2 B1 and fill down:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

where Sheet2 A1 = HP
A2 = DF
etc.


Nice work. It worked and you taught me something new. Thanks
Reply
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
finding 1 formula result in a group of cells Richdg New Users to Excel 6 June 1st 09 06:44 PM
Copy Data from One Group of Cells to Another Group Alan Auerbach Charts and Charting in Excel 2 May 27th 07 04:12 PM
How can I use the COUNTIF formula on a group of specific cells? 1day@atime Excel Discussion (Misc queries) 3 August 3rd 06 12:58 PM
how to change a formula for a large group of cells Jen Excel Worksheet Functions 1 October 2nd 05 04:42 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 07:04 PM


All times are GMT +1. The time now is 07:05 AM.

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

About Us

"It's about Microsoft Excel"