COUNTIF, VLOOKUP, needs some help to work it out please

[GingerMike]

Hi All,

I have two columns, column A with a range of 12 products down 797 rows and the next column has a value next to it.

What I want to do is look up one of the 12 product names in column A and add up the values in column B.

I am sure I have done this before and I have tried several combinations but no luck.

Any suggestions?

Thanks
Mike

[daffodil11]

PivotTable would be the fastest way.

Select data, insert PivotTable

Products as Rows, Numbers as Values


Alternatively, select Column A, Copy, Paste somewhere else.. maybe D?
Data -> Remove Duplicates
E1: =SUMPRODUCT((A1:A797=D1)*(B1:B797))

[GingerMike]

I thought someone may suggest a pivot table, having never used one before I think maybe the time has come to learn. Thanks for the response.

[RoosterReg]

Unless I'm misreading the post, try =sumif(A:A,D1,B:B)

Type the name in D1 and you'll get the sum you are after.