View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joel
 
Posts: n/a
Default How do I add multiple values that match multiple conditions?

I have been trying to do this forever. I am using this for sales metrics,
and reporting. Here is the data
Date Rep Revenue Service
01-24-2005 Joel $20 $5
01-24-2005 Bob $22 $7
01-24-2005 Joel $14 $3
01-25-2005 Joel $27 $10
01-25-2005 Joel $22 $11

Ok what I want to do is sum up how much Joel sold on 01-24-2005 ($34), So
the conditions are Joel, and the date. How would you add that up without
adding Bob's numbers in there?