Forum Discussion
JohnParham1963
Dec 11, 2020Copper Contributor
Company lookup in one column add prices in another
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'...
Riny_van_Eekelen
Dec 11, 2020Platinum Contributor
JohnParham1963 Use SUMIF, like in the picture below:
JohnParham1963
Dec 11, 2020Copper Contributor
Thanks so easy I was making much more difficult