Find and sum values based on a column search

[Chocolate-Thunder]

I have a very simple spreedsheet, it contains companies and parts and how
many times they are used per company project. I need to have a column that
will search the company name and part and return the total amount of that
specific part that the company used.concidering they will have multiple rows
in which they have used the same part.

[Marcelo]

Hi,

you can use a pivot table or sumif or sumproduct.

hth
regards from Brazil
Marcelo



"Chocolate-Thunder" escreveu:

> I have a very simple spreedsheet, it contains companies and parts and how
> many times they are used per company project. I need to have a column that
> will search the company name and part and return the total amount of that
> specific part that the company used.concidering they will have multiple rows
> in which they have used the same part.

[Marcelo]

Hi,

you can use a pivot table or sumif or sumproduct.

hth
regards from Brazil
Marcelo



"Chocolate-Thunder" escreveu:

> I have a very simple spreedsheet, it contains companies and parts and how
> many times they are used per company project. I need to have a column that
> will search the company name and part and return the total amount of that
> specific part that the company used.concidering they will have multiple rows
> in which they have used the same part.

[Chocolate-Thunder]

I'm not sure how to use those to get it to do what I need it to. It seems
more complicated than that though. It needs to search all the customers that
match the customer in the row it is in and then find all the times they use a
specific part and total all the parts used without me giving it specific
search criteria.

"Marcelo" wrote:

> Hi,
>
> you can use a pivot table or sumif or sumproduct.
>
> hth
> regards from Brazil
> Marcelo
>
>
>
> "Chocolate-Thunder" escreveu:
>
> > I have a very simple spreedsheet, it contains companies and parts and how
> > many times they are used per company project. I need to have a column that
> > will search the company name and part and return the total amount of that
> > specific part that the company used.concidering they will have multiple rows
> > in which they have used the same part.

[Chocolate-Thunder]

nevermind, figured it out, thanks

"Chocolate-Thunder" wrote:

> I'm not sure how to use those to get it to do what I need it to. It seems
> more complicated than that though. It needs to search all the customers that
> match the customer in the row it is in and then find all the times they use a
> specific part and total all the parts used without me giving it specific
> search criteria.
>
> "Marcelo" wrote:
>
> > Hi,
> >
> > you can use a pivot table or sumif or sumproduct.
> >
> > hth
> > regards from Brazil
> > Marcelo
> >
> >
> >
> > "Chocolate-Thunder" escreveu:
> >
> > > I have a very simple spreedsheet, it contains companies and parts and how
> > > many times they are used per company project. I need to have a column that
> > > will search the company name and part and return the total amount of that
> > > specific part that the company used.concidering they will have multiple rows
> > > in which they have used the same part.