Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to vlookup and summing value?
Hi, please help....
Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80 When i type on cell A1 on a separate worksheet this formula =VLOOKUP(A1,Pages!A2:B5,2,FALSE) , it only provide me $100. Is there a way to sum up the total to be $230 under "James"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to vlookup and summing value?
Hi,
=SUMPRODUCT((A1:A15="James")*(B1:B15)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Carrie" wrote: Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80 When i type on cell A1 on a separate worksheet this formula =VLOOKUP(A1,Pages!A2:B5,2,FALSE) , it only provide me $100. Is there a way to sum up the total to be $230 under "James"? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to vlookup and summing value?
Look in the help index for SUMIF
-- Don Guillett Microsoft MVP Excel SalesAid Software "Carrie" wrote in message ... Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80 When i type on cell A1 on a separate worksheet this formula =VLOOKUP(A1,Pages!A2:B5,2,FALSE) , it only provide me $100. Is there a way to sum up the total to be $230 under "James"? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to vlookup and summing value?
Hi,
I assume you enter a name to be summarized in B1 =sumproduct((B1=Pages!A2:A5)*(Pages!B2:B5)) "Carrie" wrote: Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80 When i type on cell A1 on a separate worksheet this formula =VLOOKUP(A1,Pages!A2:B5,2,FALSE) , it only provide me $100. Is there a way to sum up the total to be $230 under "James"? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to vlookup and summing value?
Hi,
You may create a pivot table. Drag column A to the row area and column B to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Carrie" wrote in message ... Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80 When i type on cell A1 on a separate worksheet this formula =VLOOKUP(A1,Pages!A2:B5,2,FALSE) , it only provide me $100. Is there a way to sum up the total to be $230 under "James"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup & summing | Excel Worksheet Functions | |||
vlookup & sum? or maybe summing dupes? | Excel Discussion (Misc queries) | |||
summing all results in a vlookup | Excel Worksheet Functions | |||
Summing vlookup cells | Excel Worksheet Functions | |||
Summing using VLOOKUP | Excel Discussion (Misc queries) |