look up same values in coumn1 and calculate values in 2nd column

  • Thread starter Thread starter khan
  • Start date Start date
K

khan

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.
 
If you only need to calculate the sum for one company:
C1: Company name
D1: =SUMIF(A1:A1000,C1,B1:B1000)

If you need the totals for all (or many) companies, I'd consider a Pivot
Table.

I hope that helps.
 
Try =SUMIF(your range for Company,Name of Company you are looking to
Sum,your range for Cost)
 
Try =SUMIF(your range for Company,Name of Company you are looking to
Sum,your range for Cost)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIF 3
Sum values from a vlookup 2
Looking up Text as a result of a formula 1
Largest value in column A based on conditions in columns B and C 6
Lookup multiple cell values and place contents in a single cell 3
Countif with 2 conditions 7
DSum - criteria in different row than value to sum 2
SUMPRODUCT....and then some! 6

Back
Top