Try =SUMIF(your range for Company,Name of Company you are looking to
Sum,your range for Cost)
Ilan
khan wrote:
I have a sheet which has 2 columns. One is called company and other is
called "cost". I want a function which will look for a company in the
whole column and and calculate the cost in 2nd column for the company.
Like column one is full with name of compaies(khan And Co, John & Co,
Rich & sons). these companies are repeated 50 times in column one.
Can any one help me out, Is it possible to do that.