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"?

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"?

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"?

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"?

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"?