Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|