Sumprouct with Indext?
 

Help

I have an issue that I ran into.

COLUMNS and Rows below data set

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


A name B calls

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

Sumprouct with Indext?
 

Thank you Claus both work great

On Thursday, February 25, 2016 at 12:53:15 PM UTC-6, wrote:
Help

I have an issue that I ran into.

COLUMNS and Rows below data set

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


A name B calls