vlookup search for more then one answer
 

i want to create a formula that will add up all the results for the same
person in question. i'm thinking it should be a vlookup formula.

so on jun 29 john sold 3 phones; on june 3 john sold 2 phones.

worksheet one cell a1, john's name, cell b1, total number of sales.

worksheet two, cell a1, john's name, cell b1, date, cell c1 total sales.

how do i make the formula read all the johns and give me the sum of all the
sales?

thanks lots,

do you want a Sum of the sales or a list of the sales
if you just need a sum, look at the sumif() function
=sumif(namelist,name,saleslist)

if there are several sheets it can be on just add a sumif function for each
sheet

"Gemse" wrote:

i want to create a formula that will add up all the results for the same
person in question. i'm thinking it should be a vlookup formula.

so on jun 29 john sold 3 phones; on june 3 john sold 2 phones.

worksheet one cell a1, john's name, cell b1, total number of sales.

worksheet two, cell a1, john's name, cell b1, date, cell c1 total sales.

how do i make the formula read all the johns and give me the sum of all the
sales?

thanks lots,

that's great! that's just the thing i was looking for.

"bj" wrote:

do you want a Sum of the sales or a list of the sales
if you just need a sum, look at the sumif() function
=sumif(namelist,name,saleslist)

if there are several sheets it can be on just add a sumif function for each
sheet

"Gemse" wrote:

i want to create a formula that will add up all the results for the same
person in question. i'm thinking it should be a vlookup formula.

so on jun 29 john sold 3 phones; on june 3 john sold 2 phones.

worksheet one cell a1, john's name, cell b1, total number of sales.

worksheet two, cell a1, john's name, cell b1, date, cell c1 total sales.

how do i make the formula read all the johns and give me the sum of all the
sales?

thanks lots,