SUMIF LEFT FORMULA

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
=SUMIF(LEFT(A5)="4",L3:L18)
Please correct this formula
I am trying to add column L, if the corresponding cell in column A has account number that starts with "5"

thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
thank you Houdini
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I learned something new today
thanks
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473

ADVERTISEMENT

Can also use

=SUMIF(A3:A18,C1&"*",B3:B18)

Where C1 holds 4
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
just_jon said:
Can also use

=SUMIF(A3:A18,C1&"*",B3:B18)

Where C1 holds 4

:eek: A *big* caveat regards the above: Assumes that your Account Numbers are formatted as Text, not General / Numeric.

Will fail if not.

This message brought to you by the proof-reading firm of Aladin & Houdini, GbmH. :LOL:
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thanks
Jon
 

Watch MrExcel Video

Forum statistics

Threads
1,118,458
Messages
5,572,249
Members
412,451
Latest member
newbie22922792
Top