Use cells to hold the criteria...
F2 = Jason
G2 = 1
H2 = Municipal
=SUMPRODUCT(--(A2:A7=F2),--(B2:B7=G2),--(C2:C7=H2),D2
7)
If you're using Excel 2007:
=SUMIFS(D2
7,A2:A7,F2,B2:B7,G2,C2:C7,H2)
--
Biff
Microsoft Excel MVP
"Jarod" wrote in message
news
Example:
A B C
D
Person Period Sales Type Commision
Mary 1 Industrial
$500
Jason 1 Municipal $1000
Mary 2 Municipal $700
Jason 2 Industrial
$1500
Mary 1 Municipal $750
Jason 1 Municipal $410
I would like to know, how much commision Jason had for his Municipal sales
in period 1.