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