hey,

I want to write a formula that can search for a date and an area in list of information and the calculate the Qty given


A B C
02/06/14 Area1 30
02/06/14 Area2 25
02/06/14 Area1 32
03/06/14 Area2 30
03/06/14 Area2 30
03/06/14 Area1 26
04/06/14 Area1 30
04/06/14 Area2 30
etc.

there are other fields such as different product codes but they aren't important for this search which is the reason the data looks repeated

can anyone help?