# SUMIF LEFT FORMULA

#### srizki

##### Well-known Member
=SUMIF(LEFT(A5)="4",L3:L18)
I am trying to add column L, if the corresponding cell in column A has account number that starts with "5"

thanks

### 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.

#### barry houdini

##### MrExcel MVP
Try

=SUMPRODUCT((LEFT(A3:A18)="5")+0,L3:L18)

#### srizki

##### Well-known Member
thank you Houdini

#### srizki

##### Well-known Member
I learned something new today
thanks

#### just_jon

##### Legend

Can also use

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

Where C1 holds 4

#### just_jon

##### Legend
just_jon said:
Can also use

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

Where C1 holds 4

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.

Thanks
Jon

Replies
2
Views
87
Replies
2
Views
88
Replies
2
Views
96
Replies
5
Views
219
Replies
11
Views
244