I think I need to use sumproduct for this. I want to add two columns based
on matching of one criteria.

For example

A B C D
---------------------------------------------------------
User A 3 User A 6
User B 4 User B 5
User A 5 User B 3

So my results for User A would by 14 and User B would be 12