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,
|