SUMIFS With Partial Criteria Match

[masouder]

Will the SUMIFS (and SUMIF) function work when the criteria match is not exact? See example below. I am trying to sum all values from the table in cell F5 where the code begins with A40 (cell F4). This would include all yellow-highlighted cells. I can add a column to the table that shows just the first three characters from the code, but I'd like to avoid that additional step if I can.

Book1
	B	C	D	E	F
3	Code	Amount
4	A1010	1		Code	A40
5	A1020	2		Total	???
6	A2010	3
7	A4010	4
8	A4020	5
9	A4030	6
10	A4040	7
11	A4090	8
12	A6010	9
13	A6020	10
14	A9010	11
15	A9020	12
16	A9030	13
17	A9040	14
Sheet1

Any help is appreciated.

 

[Fluff]

How about

=SUMIFS(C:C,B:B,F4&"*")

 

[etaf]

=SUMIF(A2:A15,E2&"*",B2:B15)

Book12
	A	B	C	D	E
1	Code	Amount
2	A1010	1		Code	A40
3	A1020	2		Total	30
4	A2010	3
5	A4010	4
6	A4020	5
7	A4030	6
8	A4040	7
9	A4090	8
10	A6010	9
11	A6020	10
12	A9010	11
13	A9020	12
14	A9030	13
15	A9040	14
Sheet2

Cell Formulas
Range	Formula
E3	E3	=SUMIF(A2:A15,E2&"*",B2:B15)

 

[masouder]

Perfect, thank you both.

 

[etaf]

you are welcome

 

[Fluff]

Glad we could help & thanks for the feedback.