Company lookup in one column add prices in another

[JohnParham1963]

Hi all,

New to this so hope you can help. I have an excel sheet with 4 columns - date 'A', company 'B', item 'C', price 'D'

what I want to achieve is every time a company is listed in column 'B' I need to add the price from column 'D'

so I want to mark 4 cells one with Company E2, I enter Company Name in F2 then in the other all the items prices from column 'D' are added together in F3. i.e.

E2.                                        F2

Company                         Screwfix

E3.                                        F3

Total                                 £56.67

Can anyone help?

Thanks 

John

[#2]

@JohnParham1963 Use SUMIF, like in the picture below:

[#3]

@JohnParham1963 

Enter the following formula in F3:

=SUMIF(B2:B11,F2,D2:D11)

[#4]

Thanks so easy I was making much more difficult