It sounds confusing, but I can not figure out how to add two different values with the same lookup criterea.
EX.
...Name.........Number
1....Mike............34
2....Joe..............65
3....Jane.............23
4....Mike.............13
5....steve............60
I want to lookup everytime mike has a number and sum them all together. For this example, I should get 47 as my result.
I cannot think of a way to do this without a lot of columbs ans repetition. I just want one clean formula. Any thoughts?
Bookmarks