Excel - Function to sum values across rows with certain features

So let us say I have a table like this:

ID	Date	Value
2	6/2		2432
2	6/2		1322
3	6/2		3534
3	6/2		6431
2	6/3		2421
2	6/2		6251
3	6/3		9870
3	6/2		3534

I want a function that will find every row with an ID "2" and a date
function with those parameters it would return 3754.

I can do this with a pivot table but I would love a formula to do it
instead. Any ideas?

Hi David,

Am Mon, 25 Jun 2012 13:19:56 -0700 (PDT) schrieb David Tannenbaum:


what excel version do you use?
xl2007 or xl2010:
=SUMIFS(C:C,A:A,2,B:B,DATE(2012,6,2))
An earlier version:
=SUMPRODUCT(--(A1:A100=2),--(B1:B100=DATE(2012,6,2)),C1:C100)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2