SUM OF GROUPS
I have two columns.
Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance |
SUM OF GROUPS
Use Subtotals.
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "ADK" wrote in message ... I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance |
SUM OF GROUPS
=SUMIF(C:C,630,D:D)
-- HTH RP (remove nothere from the email address if mailing direct) "ADK" wrote in message ... I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance |
SUM OF GROUPS
On Fri, 28 Oct 2005 14:31:58 -0400, "ADK"
wrote: I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance You could use a pivot table, or alternatively a SumIF For the pivot table just position your cursor anywhere in the data table and select Data, Pivot Table, Next, Next, Layout, drag your column C Group into the row section of the wizard, and the Col D Weights into the Data section and click OK. ALternatively get a unique list of the Group Numbers in say column E, and then in F2 enter =sumif(C:C,E2,D:D) and copy down. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
SUM OF GROUPS
Not what I am looking for. I have a separate chart for the groups.
"Anne Troy" wrote in message ... Use Subtotals. http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "ADK" wrote in message ... I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance |
SUM OF GROUPS
THANKS ...result is what I was looking for
"Bob Phillips" wrote in message ... =SUMIF(C:C,630,D:D) -- HTH RP (remove nothere from the email address if mailing direct) "ADK" wrote in message ... I have two columns. Column C is labeled: Group Column D is Labeled: Weight I have 27 rows with data. I would like to tally the group weights example: 5 of the 27 rows are under Group number 630 (the cell in column C has the value 630). Each one has a weight ...I'd like a total weight for all items with the group number 630 and so forth. I am guessing this is maybe some kind of lookup function but have no idea on how to add each room with the same group number. Thanks in Advance |
All times are GMT +1. The time now is 12:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com