Home |
Search |
Today's Posts |
#1
|
|||
|
|||
look up same values in coumn1 and calculate values in 2nd column
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. |
#2
|
|||
|
|||
Look up SUMIF in help
=SUMIF(Range1,"company",Range2) Regards, Peo Sjoblom "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. |
#3
|
|||
|
|||
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. -- Regards, Ron |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|