vlookup to sum quantities based on dates and specific person

[cantbeenuts]

I am having difficulty using vlookup capturing data from rolling up multiple
dates based on who the sales person is and the number of sales they
generated. Here is an example spread sheet...
Date Salesperson Sales
9/1 Mike 3
9/1 Will 2
9/1 Mike 1
9/2 Will 6
9/2 Will 3
9/2 Mike 8

Using vlookup and pulling from a 'data' page, the month-to-date roll up
should show Mike with 12 sales (4 on 9/1 and 8 on 9/2).

Thanks for the help.

 

[Don Guillett]

Look in the help index for SUMIF

 

[EddS]

Just use a piviot table - it will do it in 3 seconds saves a lot of time

Sum of 2 01-Sep
Mike 01-Sep 03-Sep Grand Total
John 3 3
Kike 4 4
Mike 2 2
Grand Total 4 5 9

 

[EddS]

Alternative option - use an Array with IF

Example

{=SUM(IF($A$9:$A$12=G8,IF($B$9:$B$12=$F$9,$C$9:$C$12)))}

A9:A12 is the dates , G8 is the date its is checking, B9:B12 is the names,
checking agaist the name on F9 and C9 to C12 is what you want to add
use Shift + Ctrl + Enter to put it in

 

[cantbeenuts]

I thought of using a pivot table but the reports will be much more dynamic in
terms of how they look, etc.

I have seen a vlookup formula that does what I need it to do but I am
missing a good part of it.

 

[EddS]

my date
01-Sep Mike 2
03-Sep Mike 2
03-Sep John 3
01-Sep Kike 4

my results
01-Sep 02-Sep 03-Sep
Mike 2 0 2
John 0 0 3

 

[Pete_UK]

What would you like to see in your "roll-up" page? Here's some
examples:

1.

Date Salesperson Sales
9/1 Mike 3
9/1 Mike 1
9/2 Mike 8

i.e. every row with Mike's data.

2.

Date Salesperson Sales
9/1 Mike 4
9/2 Mike 8

i.e. each day summarised for Mike.

3.

Date Salesperson Sales
Sept Mike 12

i.e. summary for September.

Presumably you would have a cell somewhere where you can select the
salesman, and another cell (or 2) to select the month (or date range)
that you are interested in.

Please give more details.

Pete

 

[cantbeenuts]

the sumif worked. thanks. I will use it in the mean time. Let me know if
you know of any vlookup that would work