Sum if the first 4 digits of a column is the same as another column's first 4 digits

[feni1388]

Hello....

Is there a formula that can sum if the first 4 digits a a column is the same as another column's 4 digits?
At the moment I'm using a helper column to take out the first 4 digits.
The total of L column that start with the same 4 digits as A column is shown in column C.

各病院の請求書（マクロ）0630 - feni test.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Customer code	Total Invoice	Individual Invoice								Invidual Invoice
2	MC010000	112,930	112,930	MC01						MC01	MC010101	112,930
3	MC020000	253,620	253,620	MC02						MC02	MC020101	187,110
4	MC030000	254,740	0	MC03						MC02	MC020201	66,510
5	MC040000	0	0	MC04
6	MC050000	214,905	0	MC05
7	SIS01000	892,040	0	SIS0
8
9
10
11
確認用

Cell Formulas
Range	Formula
A2:A11	A2	=IF(FS請求一覧表!D2="","",FS請求一覧表!D2)
B2:B11	B2	=IF(FS請求一覧表!T2="","",FS請求一覧表!T2)
C2:C7	C2	=SUMIF(J:J,D:D,L:L)
D2:D7	D2	=LEFT(A2,4)
J2:J11	J2	=LEFT(K2,4)

 

[Cubist]

Try:

Book1
	A	B	C	D							K	L
1	Customer code	Total Invoice	Individual Invoice
2	MC010000		112930								MC010101	112930
3	MC020000		253620								MC020101	187110
4	MC030000		0								MC020201	66510
5	MC040000		0
6	MC050000		0
7	SIS01000		0
Sheet10

Cell Formulas
Range	Formula
C2:C7	C2	=SUM(FILTER($L$2:$L$4,LEFT($K$2:$K$4,4)=LEFT(A2,4),0))

 

[feni1388]

Try:

Book1
	A	B	C	D							K	L
1	Customer code	Total Invoice	Individual Invoice
2	MC010000		112930								MC010101	112930
3	MC020000		253620								MC020101	187110
4	MC030000		0								MC020201	66510
5	MC040000		0
6	MC050000		0
7	SIS01000		0
Sheet10

Cell Formulas
Range	Formula
C2:C7	C2	=SUM(FILTER($L$2:$L$4,LEFT($K$2:$K$4,4)=LEFT(A2,4),0))

Thank you. It works perfectly.

 

[Phuoc]

The result is the same:

=SUMIF($K$2:$K$4,LEFT(A2,4)&"*",$L$2:$L$4)

 

[feni1388]

The result is the same:

=SUMIF($K$2:$K$4,LEFT(A2,4)&"*",$L$2:$L$4)

yes, you're right. The result is the same.
Thank you.