Sumproduct Question
 

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

Sumproduct Question
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Dthmtlgod" schrieb im Newsbeitrag
...
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

Sumproduct Question
 

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

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

Regards,
Nate Oliver