VLook up & Sum

[Luciadem]

When you do a v look up, how can you sum if you have more than one row with the same name.

For instance:

Column A Column B
ExampleA $200
ExampleB $300
ExampleA $100

So if i do a
=VLookUp(ExampleA,spreadsheet,A:B,2,0)
=200

How can I do to get 300 which is the total of ExampleA

Please help.

 

[xld]

Try

=SUMIF(A:A,"Example A",B:B)

 

[JoeMo]

When you do a v look up, how can you sum if you have more than one row with the same name.

For instance:

Column A Column B
ExampleA $200
ExampleB $300
ExampleA $100

So if i do a
=VLookUp(ExampleA,spreadsheet,A:B,2,0)
=200

How can I do to get 300 which is the total of ExampleA

Please help.

Try:

=SUMPRODUCT(--(A:A="ExampleA"),B:B)

 

[Sahak]

Hi,

You can use SUMIF:

=SUMIF(A1:B3,A1,B1:B3)