View Single Post
  #2   Report Post  
Old February 25th 16, 07:01 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default Sumprouct with Indext?

Hi,

Am Thu, 25 Feb 2016 10:53:10 -0800 (PST) schrieb
:

A(name) B(calls(
Alex 10
Alex1 5
Robert 12
Robert1 6

Basically I need to look up Alex and Alex1 and add their calls
Combined added below


try:
=SUMPRODUCT(((A2:A100="Alex")+(A2:A100="Alex1"))*B 2:B100)
or
=SUMPRODUCT(--(LEFT(A2:A100;4)="Alex");B2:B100)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional