SumIfs with Left() as a Criteria

[gheyman]

Can you do a SumIfs formula where the Criteria is looking at the first 3 characters]

I want to Sum Column A where in Column C the first three letters are "DLE". Is this possible?

 

[Joe4]

Sure. Just use "DLE*" as criteria for that column, i.e.

=SUMIFS(A:A,C:C,"DLE*")

I am assuming that you have other criteria too, or else you could just use SUMIF instead of SUMIFS.

 

[Fluff]

How about
=SUMIF(C:C,"DLE*",A:A)

 

[Dave Patton]

Two ideas to try

Excel 2010
	A	B	C	D	E
1	Amount
2	100		DLEav	1300	1300
3	20		Devel
4	300		DLEav
5	400		DLEav
6	500		DLE
1a

Cell Formulas
Range	Formula
D2	=SUMIF(C2:C6,"DLE*",A2:A6)
E2	=SUMIFS(A2:A6,C2:C6,"DLE*")

 

[gheyman]

Thanks, Joe. Yes I do. But I almost always do SimIfs even if I only have one Criteria.

And thank you to everyone else.

 

[Fluff]

Glad we could help & thanks for the feedback