Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT question | Excel Discussion (Misc queries) | |||
Sumproduct question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Worksheet Functions | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
SUMPRODUCT QUESTION | Excel Discussion (Misc queries) |