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,