View Single Post
  #1  
Old April 12th, 2010, 06:18 PM posted to microsoft.public.excel.newusers
Jarod
external usenet poster
 
Posts: 23
Default Sumif with a few criteria

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.