Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
#3
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
VLOOKUP to search multiple values? | Excel Worksheet Functions | |||
how to set up a vlookup table with 2 search terms? | Excel Worksheet Functions | |||
How do I use VLOOKUP to search for text? | Excel Worksheet Functions |