Sumproduct Question

[Dthmtlgod]

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

 

[Frank Kabel]

Hi
=SUMIF(A:A,"User A",B:B)+SUMIF(C:C,"User A",D)

But you may consider also changing your layout to a 2-column layout

 

[Guest]

Hello, for a single sumproduct() call, try:

=SUMPRODUCT((A11:A13="User A")*(B11:B13)+(C11:C13="User A")*(D1113))
=SUMPRODUCT((A11:A13="User B")*(B11:B13)+(C11:C13="User B")*(D1113))

Regards,
Nate Oliver