Function to sum values across rows with certain features

D

David Tannenbaum

So let's 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
"6/2", and then add together all the "Values". So if I ran the
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?
 
C

Claus Busch

Hi David,

Am Mon, 25 Jun 2012 13:19:56 -0700 (PDT) schrieb David Tannenbaum:
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
"6/2", and then add together all the "Values". So if I ran the
function with those parameters it would return 3754.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top