Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if or SumProduct
I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the same makes/models due to different territories. I have a separate worksheet for which I need to summarize this info. What would be the best formula for this task? I guess I am lost on what to enter to count. Any help is greatly appreciated! Thank you, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if or SumProduct
Hi,
Try this. The lookup value is in A1 of the currebt sheet =SUMPRODUCT((Sheet1!A1:A20=A1)*(Sheet1!B1:B20)) Mike "Brandy" wrote: I have two columns : column A defines the make/model; column B numerically defines how many were sold . Note: There are multiple entries for the same makes/models due to different territories. I have a separate worksheet for which I need to summarize this info. What would be the best formula for this task? I guess I am lost on what to enter to count. Any help is greatly appreciated! Thank you, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if or SumProduct
Is this what you had in mind:
Sheet1 ...........A...........B 1....Model.....AMT 2.......x.............3 3.......z.............1 4.......x.............5 5.......y.............4 Sheet2 ...........A...........B 1....Model.....Total 2.......x.............8 Enter this formula in Sheet2 B2: =SUMIF(Sheet1!A$2:A$5,A2,Sheet1!B$2:B$5) -- Biff Microsoft Excel MVP "Brandy" wrote in message ... I have two columns : column A defines the make/model; column B numerically defines how many were sold . Note: There are multiple entries for the same makes/models due to different territories. I have a separate worksheet for which I need to summarize this info. What would be the best formula for this task? I guess I am lost on what to enter to count. Any help is greatly appreciated! Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT, count & sum | Excel Worksheet Functions | |||
count if or sumproduct? | Excel Discussion (Misc queries) | |||
Count without SUMPRODUCT | Excel Worksheet Functions | |||
SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
Count if and Sumproduct | Excel Discussion (Misc queries) |