Find and sum values based on a column search
 

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.

Find and sum values based on a column search
 

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.

Find and sum values based on a column search
 

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.

Find and sum values based on a column search
 

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.