VLOOKUP?

T

tojo107

I have a spreadsheet that lists sales reps number of orders.It is broken down by division. A rep will have orders in multiple divisions. I want to LOOKUP by name and pull the total number of orders in either a new column or spreadsheet, whatever is easier. The only thing I relly care about totaling is the total number of orders, not dollars or average$$. Thank You!!

Example Date

Orders New Demand Avg $
Divisions: PY

AMROCK,MICHELLE 189 10,051.97 $53.1
BAILEY,KRYSTLE 96 4,207.99 $43.8
CHAPMAN,JUNE 219 11,924.74 $54.4
CRONAN,SHIRLEY 324 18,371.34 $56.7
LOPES,MARIA 412 18,675.08 $45.3
Division Total: EY 18,021 1,032,932.34 $57.32


AMROCK,MICHELLE 102 6,901.99 $67.6
BAILEY, KRYTLE 28 3,705.00 $132.3
CHAPMAN,JUNE 60 6,685.75 $111.4
HARRISON,JOYCE 53 2,534.74 $47.8
VENTURA,KARA 9 564.00 $62.6
Divisions: Heart of Gold

AMROCK,MICHELLE 2 0.00 $0.0
BAILEY, KRYSTLE 20 2,132.75 $106.6
CHAPMAN, JUNE 23 1,441.00 $62.6
KIMBALL, NANCY 8 930.50 $116.3
LEBLANC,PATRICIA 29 2,861.92 $98.6
 
D

Don Guillett

if you just want to count joes orders use countif

or sumif should do more
=sumif(a2:a22,"joe",b2:b22)
or sumproduct for that & more
=sumproduct(a2:a22="Joe")*(b2:b22))

--
Don Guillett
SalesAid Software
[email protected]
tojo107 said:
I have a spreadsheet that lists sales reps number of orders.It is broken
Click to expand...
down by division. A rep will have orders in multiple divisions. I want to
LOOKUP by name and pull the total number of orders in either a new column or
spreadsheet, whatever is easier. The only thing I relly care about totaling
is the total number of orders, not dollars or average$$. Thank You!!!
 
Top