Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Data
Thought I knew how to do this, but not even sure which function I now need!
I have two worksheets. INPUT SHEET A list which basically has fields Product Description, Group Code and Tonnage. e.g. Wheatfeed, WH, 10.00 OUTPUT SHEET Is a form which we have to send off summarising our business activity based on the INPUT SHEET. Simply put it has the fields Group Code, Group Description and Total Tonnage. e.g. WH, Wheat Products, 500.00 Its the Total Tonnage column in which I want to put formula into which looks in the Input Sheet and totals up all the products which have the same code as listed in the first column of the Output Sheet e.g. WH. Any ideas???! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Data
=SUMIF('Input Sheet'!$B:$B,A2,'Input Sheet'!$C:$C) -- __________________________________ HTH Bob "Ruth" wrote in message ... Thought I knew how to do this, but not even sure which function I now need! I have two worksheets. INPUT SHEET A list which basically has fields Product Description, Group Code and Tonnage. e.g. Wheatfeed, WH, 10.00 OUTPUT SHEET Is a form which we have to send off summarising our business activity based on the INPUT SHEET. Simply put it has the fields Group Code, Group Description and Total Tonnage. e.g. WH, Wheat Products, 500.00 Its the Total Tonnage column in which I want to put formula into which looks in the Input Sheet and totals up all the products which have the same code as listed in the first column of the Output Sheet e.g. WH. Any ideas???! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Data
=SUMIF('Input Sheet'!B:B,A2,'Input Sheet'!C:C)
Regards, Stefi €˛Ruth€¯ ezt Ć*rta: Thought I knew how to do this, but not even sure which function I now need! I have two worksheets. INPUT SHEET A list which basically has fields Product Description, Group Code and Tonnage. e.g. Wheatfeed, WH, 10.00 OUTPUT SHEET Is a form which we have to send off summarising our business activity based on the INPUT SHEET. Simply put it has the fields Group Code, Group Description and Total Tonnage. e.g. WH, Wheat Products, 500.00 Its the Total Tonnage column in which I want to put formula into which looks in the Input Sheet and totals up all the products which have the same code as listed in the first column of the Output Sheet e.g. WH. Any ideas???! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Data
Thanks Bob - that does the trick beautifully! I knew there was a way!!!
"Bob Phillips" wrote: =SUMIF('Input Sheet'!$B:$B,A2,'Input Sheet'!$C:$C) -- __________________________________ HTH Bob "Ruth" wrote in message ... Thought I knew how to do this, but not even sure which function I now need! I have two worksheets. INPUT SHEET A list which basically has fields Product Description, Group Code and Tonnage. e.g. Wheatfeed, WH, 10.00 OUTPUT SHEET Is a form which we have to send off summarising our business activity based on the INPUT SHEET. Simply put it has the fields Group Code, Group Description and Total Tonnage. e.g. WH, Wheat Products, 500.00 Its the Total Tonnage column in which I want to put formula into which looks in the Input Sheet and totals up all the products which have the same code as listed in the first column of the Output Sheet e.g. WH. Any ideas???! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing like data | Excel Discussion (Misc queries) | |||
Summing up Data | Excel Worksheet Functions | |||
summing data | Excel Discussion (Misc queries) | |||
summing data | Excel Worksheet Functions | |||
Summing data | Excel Discussion (Misc queries) |