Good evening,

I'm facing a problem making my excel. I have a certain set of data having the companies names in column B2:B101 ( Lot of entries with same companies name but different values in Column D ). and the values in D2:D101, inclusive of negative values also.

is it possible to find out the company name with all the values present in column D in front of all the same name.

For Eg. If the company ABC has 6 entries all over the column B but with different values. So is it possible to list the name ABC once and with SUM of all the six entries in front of ABC ?

If yes then please guide how do I do it..

I hope I am not confusing you all by my question.

Thanks & Regards

Avinash