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?
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?