Quote Originally Posted by lesoies View Post
SUMIF looks like it should work which is the frustrating part - do you know why it doesn't? i was hoping that i just had some kind of weird syntax error.
Nope! Like I said in post #3. SUMIF only work "straight comparison"

Example: SUMIF(A:A,"apple",B:B)