Thread: Sumproduct Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nate Oliver[_3_] Nate Oliver[_3_] is offline
external usenet poster
  
Posts: 71
Default 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 With QuoteReply With Quote