Here is my current format:
Agent Name LF Deal TTC Office NP Agent NP Brach Metro
Farber , Jean $10,017 $3,719 $5,696 1358 NY
Tynan , Diane $255 $83 $157 1358 NY
Alves , Rui $10,625 $4,994 $4,994 1360 CT
SEIDEN , MARK $12,500 $1,763 $9,988 1250 CT
Hughes , Margaret $875 $263 $559 1460 CT
Hughes , Margaret $775 $233 $495 1460 CT
Hughes , Margaret $700 $211 $447 1460 CT
Kennedy , Nancy $12,855 $3,081 $9,002 2502 CA
Kennedy , Nancy $0 ($452) $452 2502 CA
MacIntyre , Helena $7,375 $2,738 $4,194 3212 NY
McDuffey , Deborah $1,209 $526 $610 3212 CT
Wiland-Fillebrown $12,855 $3,127 $5,936 3500 IL
Wiland-Fillebrown $0 ($298) $298 3500 IL
FioRito , Rebekah $600 $169 $395 3612 FL
FLOOD , PATRICIA $700 $303 $355 3700 NY
Kotlyar , Tatiana $700 $329 $329 2600 FL
Lopez , Laura $750 $353 $353 2600 CA
Luburic , Vesna $800 $263 $489 1500 IL
McGinnis , James $7,925 $2,794 $4,656 1500 OH
McGinnis , James $8,568 $3,020 $5,034 1500 OH
McGinnis , James $8,041 $2,834 $4,724 1500 OH
McGinnis , James $12,391 $4,368 $7,280 1500 OH
Westervelt , Janet $28,125 $13,219 $12,969 1700 FL
Berliner , Lisa $525 $207 $286 1700 FL
Curro , Alma $14,625 $6,874 $6,874 1700 FL
Keane , Kay $238 $55 $169 1750 CA
Keane , Kay $25,000 $4,318 $13,307 1750 CA
Kevelin , Christina $6,641 $2,466 $3,777 1800 OH
Kevelin , David $6,641 $2,466 $3,777 1800 OH
Nowak , Carine $26,250 $7,403 $17,273 2000 CA
Ornstein , David $1,903 $537 $1,252 2025 CA
Russell , Donald $10,824 $3,052 $7,122 2025 CA
Russell , Donald $5,267 $1,485 $3,466 2025 CA
What i would like to do is the following:
Sum the production for each agent so their names are not repeating. After summing I would lke be able to sort by Branch, Agent, or even Metro without losing the sums.
How would you write the sumproduct formula for the above? I am not familiar with Pivot Tables (Please Advise).
Thanks.