M
monkeytrader
Can anyone help me with this?
Cell A B C D
10 abc 22
11 xyz 15
12 xyz 10
13 abc 23
14 xyz 46
I want to search through column A for every cell that is "abc" and return
the corresponding number from column B. Then, I'd like a sum of the results.
So, thre result should show "45" from "abc"... Sorry this is a bit vague,
but I'm stumped. Hope someone can help. Really appreciate it.
Cell A B C D
10 abc 22
11 xyz 15
12 xyz 10
13 abc 23
14 xyz 46
I want to search through column A for every cell that is "abc" and return
the corresponding number from column B. Then, I'd like a sum of the results.
So, thre result should show "45" from "abc"... Sorry this is a bit vague,
but I'm stumped. Hope someone can help. Really appreciate it.