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