Spend half an hour to google/learn Pivot Tables. Formula solutions may seem
familiar and safe and sufficient, but a Pivot is way faster and unbelievably
powerful.

Best wishes Harald


"Jarod" skrev i melding
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.