Sumifs with =left() criteria

Doing a sumifs formula and I want to reference just the first two characters of a column of data like below.

=sumifs(sales,left(warehouse,2),"pw")........)

I want to total sales of all warehouses that begin with the letters "pw" but I can't get it to work.

Any ideas?

Not quite but you might be able to help me figure it out.

examples in the warehouse column will be as follows. pw01,pw02,pw15,pw21,pwpd,pw29,al01,al03,alpd,al21,ge01,ge12,gepd,ge20,jgpd

I want to total all sales in pwpd.....easy
I want to total all sales in gepd....easy
I want to total all sales that start with pw but not pwpd

I guess I can do the pwpd sum, then subtract that total from the pw* sum......unless there is a better way.

I hope this makes since

You could add another criteria for <>pwpd
=SUMIFS(sales,warehouse,"pw*",warehouse,"<>pwpd*")........)

Looks like that worked. Thank you!!

You're welcome.