Company lookup in one column add prices in another

Question

Hi all,&nbsp;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.&nbsp;E2. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F2Company &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ScrewfixE3. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F3Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; £56.67&nbsp;Can anyone help?&nbsp;Thanks&nbsp;&nbsp;John

riny_van_eekelen · Answer

JohnParham1963&nbsp;Use SUMIF, like in the picture below:

hansvogelaar · Answer

JohnParham1963&nbsp;
Enter the following formula in F3:
&nbsp;
=SUMIF(B2:B11,F2,D2:D11)

johnparham1963 · Answer

Thanks so easy I was making much more difficult

Forum Discussion

Company lookup in one column add prices in another

3 Replies

Resources